aboutsummaryrefslogtreecommitdiff
path: root/handlers/pgsql.in
AgeCommit message (Collapse)Author
2012-02-25pgsql: don't produce empty uncompressed backups (Redmine#3820).intrigeri
2011-04-25All handlers: stop using "local VAR" outside functions. (Closes: #530647)intrigeri
2010-11-07Fix reliance on bash for pipefail. (Closes: #602374)intrigeri
Thanks to Sergio Talens-Oliag <sto@debian.org> for the bug report and patch.
2010-10-19Removed extra '.' in plain/sql dumpsJacob Anawalt
Removed an extra '.' in file names introduced by the pg_dump options patch, resulting in names like db..sql or db..sql.gz instead of just db.sql or db.sql.gz.
2010-10-12Enable pg_dump format option.Jacob Anawalt
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.
2010-06-14Added GZIP_OPTS option, defaulting to --rsyncable.intrigeri
... so that this option can be disabled on systems that don't support it. This also allows to use another compression program, such as pbzip2 on SMP machines (closes Roundup bug #2405).
2010-01-08ldap,mysql,pgsql: use bash pipefail option so that failed dumps are reported ↵intrigeri
as such This should fix Redmine bug #1340. This option makes pipelines return as status the value of the last (rightmost) command to exit with a non-zero status, or zero if all commands exit successfully. See bash(1) for details. E.g. this prevents the following from exiting with status 0 (!) if pg_dumpall fails: pg_dumpall | gzip
2009-12-25mysql, pgsql: Quote output filenamesintrigeri
... to support shell meta-characters in database names. Closes Redmine bug #617.
2009-11-19ldap, mysql, pgsql: use gzip's --rsyncable optionintrigeri
2009-05-23Add a vim modeline with indentation settings.Matthijs Kooijman
The modelines added match the emacs lines already present and also set the filetype to sh (just like the emacs lines).
2009-05-23Make all indentation consistent.Matthijs Kooijman
Previously, there were many indentation styles in use: Real tabs, 2, 3 or 4 spaces, mixing these within the same file, function or even within a single line. This commit changes all bash scripts in the handlers, src and lib dirs to use consistent indentation: three spaces are now used everywhere. Other files (e.g. Makefiles) are left untouched. Additionally, this commit removes all trailing whitespace.
2008-06-24pgsql, mysql, svn: use new vservers_running function from lib/vserver ↵intrigeri
(factorization++)
2008-06-24pgsql: clarify error message when backupdir does not existintrigeri
2007-10-12fixed autotools build, broken since r466, inhandlers/Makefile.amintrigeri