Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group