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
ssh root@dbserver 'sudo -Hu postgres /usr/lib/postgresql/9.4/bin/pg_dumpall | gzip -f9' > output.sql.gz