Backup And Restore Postgresql Databases

Posted By Weston Ganger

Its handy to know how to backup and restore your databases in postgresql from the command line

Backup / Restore a Single Database

# 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