I am currently looking for a software/web development job preferably as a Rails-based developer.
Please email me at email@example.com. Thanks in advance for any leads!
How To 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
# 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: