postgresql.conf archive_command example

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: postgresql.conf archive_command example
Date: 2011-08-30 18:39:15
Message-ID: 1314729555.11209.8.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I think it would be useful to add the following explanation and sample
to the postgresql.conf sample file:

diff --git i/src/backend/utils/misc/postgresql.conf.sample w/src/backend/utils/misc/postgresql.conf.sample
--- i/src/backend/utils/misc/postgresql.conf.sample
+++ w/src/backend/utils/misc/postgresql.conf.sample
@@ -186,6 +186,9 @@
#archive_mode = off # allows archiving to be done
# (change requires restart)
#archive_command = '' # command to use to archive a logfile segment
+ # placeholders: %p = path of file to archive
+ # %f = file name only
+ # e.g. 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f'
#archive_timeout = 0 # force a logfile segment switch after this
# number of seconds; 0 disables

This corresponds to what we have in the documentation and mirrors the
example in recovery.conf.sample.

Objections?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Brendan Jurd 2011-08-30 18:45:18 Re: postgresql.conf archive_command example
Previous Message Peter Eisentraut 2011-08-30 18:32:56 Re: pg_upgrade automatic testing