database not restoring from dump file
I had to run

CREATE DATABASE databasename;


to manually create the db, and then changed the restore command to:

devserver:/# psql -f prod.sql -U postgres -d databasename