Backup commands
- pg_dump db_name > db_backup.sql
- pg_dumpall > cluster_backup.sql
Restore commands
- psql db_name < db_backup.sql
- psql -f cluster_backup.sql postgres
Using compression
- pg_dump db_name | gzip > db_backup.gz
- pg_dumpall | gzip > cluster_backup.gz
Restore
- gunzip -c db_backup.gz | psql db_name
- gunzip -c cluster_backup.gz | psql postgres
reference:
https://www.rubytreesoftware.com/resources/basic-postgresql-backup-and-restore/
Subscribe to:
Post Comments (Atom)
-
In my current company, I'm using Visual Paradigm for my documentation task. If you go there site, you can either download community and ...
-
One of the functionality in our system is can able to generate a report using Jasper report. We have a Jasper server setup in another ip ad... -
https://www.liquidweb.com/kb/how-to-install-nvm-node-version-manager-for-node-js-on-ubuntu-12-04-lts/
No comments:
Post a Comment