From 7355535ee18efc472f5a598b8474e8d05765d6f1 Mon Sep 17 00:00:00 2001 From: Jacob Anawalt Date: Mon, 11 Oct 2010 18:53:00 -0600 Subject: Enable pg_dump format option. The format option of pg_dump enables tar and custom archive file formats in addition to the default plain-text file containing SQL commands. When either the tar or custom format are selected the behaviour of database=all is changed to no longer dump a single file via pg_dumpall. Instead pg_dumpall is called once to export the "global" data (roles & tablespaces) and then pg_dump is called once for each non-template table in the database. To support the GZIP and GZIP_OPTS variables in backupninja and to give the default --rsyncable gzip compression flag a chance at working on a PostgreSQL backup, the custom output is forced to not use compression. Instead compression is done via a pipe to gzip. Hopefully this benefits rsync and rdiff-backup style backups for reduced backup and storage costs that outweigh the restoration ones. --- src/backupninja.in | 1 + 1 file changed, 1 insertion(+) (limited to 'src') diff --git a/src/backupninja.in b/src/backupninja.in index 789debd..aadc162 100755 --- a/src/backupninja.in +++ b/src/backupninja.in @@ -476,6 +476,7 @@ getconf MYSQLADMIN /usr/bin/mysqladmin getconf MYSQL /usr/bin/mysql getconf MYSQLHOTCOPY /usr/bin/mysqlhotcopy getconf MYSQLDUMP /usr/bin/mysqldump +getconf PSQL /usr/bin/psql getconf PGSQLDUMP /usr/bin/pg_dump getconf PGSQLDUMPALL /usr/bin/pg_dumpall getconf PGSQLUSER postgres -- cgit v1.2.3