Main Page/IT/Postgresql

From Lewis Consultancy Wiki
< Main Page‎ | IT
Jump to: navigation, search

Back 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