Difference between revisions of "Main Page/IT/Postgresql"
From Lewis Consultancy Wiki
Jump to navigationJump to search (Created page with "===Back up a database remotely with compression=== <pre>ssh root@dbserver 'sudo -Hu postgres /usr/lib/postgresql/9.4/bin/pg_dump dbname | gzip -f9' > output.sql.gz</pre>") |
(No difference)
|
Revision as of 11:42, 4 February 2016
Back up a database remotely with compression
ssh root@dbserver 'sudo -Hu postgres /usr/lib/postgresql/9.4/bin/pg_dump dbname | gzip -f9' > output.sql.gz