- publishing free software manuals
The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration Guide
by The PostgreSQL Global Development Group
Paperback (6"x9"), 274 pages
ISBN 9781906966072
RRP £9.95 ($14.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

10.3.5.2 archive_command scripts

Many people choose to use scripts to define their archive_command, so that their ‘postgresql.conf’ entry looks very simple:

archive_command = 'local_backup_script.sh'

Using a separate script file is advisable any time you want to use more than a single command in the archiving process. This allows all complexity to be managed within the script, which can be written in a popular scripting language such as bash or perl. Any messages written to stderr from the script will appear in the database server log, allowing complex configurations to be diagnosed easily if they fail.

Examples of requirements that might be solved within a script include:

ISBN 9781906966072The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration GuideSee the print edition