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

Re: postgresql.conf archive_command example

From: Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: postgresql.conf archive_command example
Date: 2011-08-31 09:18:54
Message-ID: CAF6yO=22YQviDYJKzAyi-Y1P=xU2nH=1FU0g29j_333H87bdxg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
2011/8/30 Peter Eisentraut <peter_e(at)gmx(dot)net>:
> 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?

No objections, it is welcome.
Just a question: can we build a different postgresql.conf for windows
or do we add a windows command example here as well ?

>
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>



-- 
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation

In response to

Responses

pgsql-hackers by date

Next:From: Albe LaurenzDate: 2011-08-31 09:34:31
Subject: Re: postgesql-9.0.4 compile on AIX 6.1 using gcc 4.4.6
Previous:From: Peter EisentrautDate: 2011-08-31 08:16:26
Subject: Re: Comparing two PostgreSQL databases -- order of pg_dump output

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