Main Page/IT/Postgresql
From Lewis Consultancy Wiki
Jump to navigationJump to searchBack up a database remotely with compression
ssh root@dbserver 'sudo -Hu postgres /usr/lib/postgresql/9.4/bin/pg_dumpall | gzip -f9' > output.sql.gz
- This page was last edited on 4 February 2016, at 12:00.
- Privacy policy
- About Lewis Consultancy Wiki
- Disclaimers