Its handy to know how to backup and restore your databases in postgresql from the command line
Backup / Restore a Single Database
# If you dont have permissions on your current user login switch to postgres user first
sudo su - postgres
# To Backup
pg_dump your_database_name > backup_file_name
# To Restore
createdb your_database_name
psql your_database_name < backup_file_name
Backup / Restore All Databases on the Server
# To Backup All
pg_dumpall > backup_file_name
# To Restore All with the default database
psql -f backup_file_name postgres
# To Restore All with the default database of current user
psql -f backup_file_name $USER
Related External Links: