
Postgres / PSQL importing a database
When you have backed up a database, and are restoring it (and if you are using the PSQL command line tool), don’t forget to add the database name to the end of the command line:
psql -U postgres -h hostname -f file_you_want_to_import "**database_name**"
Don’t forget the double quotes.