Tag Archives: postgres

Backup / restore PostgreSQL database

To backup / dump entire DB (database cluster), use the following command: pg_dumpall > outfileor with username and gzipped pg_dumpall -U postgres | gzip > db_backup.gz-U usename – connect as specified database user To restore from dump file “db_backup” use: … Continue reading

Posted in Databases | Tagged , | Leave a comment