Thank you so much for all your help! I really appreciate it. It turns out that I was trying to use the latest postgresql version whereas the dump.sql was from a previous version. I discovered this while trying to follow the guide you used. Thank you!