how to backup a single project database and restore it?

[remkonoteboom]

The postgres commands to dump a database are:

pg_dump -U <user> <database> > database.sql

To restore this, you can use:

psql -U <user> <database> < database.sql

To dump and restore all of your databases you would use pg_dumpall