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

Re: 9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "L'Huillier, Jeff" <Jeff(dot)LHuillier(at)ONSTAR(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: 9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename
Date: 2012-04-11 14:08:41
Message-ID: 22265.1334153321@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"L'Huillier, Jeff" <Jeff(dot)LHuillier(at)ONSTAR(dot)com> writes:
> When enabling WAL archiving and setting up the archive_command, is it
> possible to add the date & time as an extension to the %f copied to the
> archive directory in order to avoid overwriting a file of the same name?

Why would you think that's necessary?  Please see the recommendations
for archive scripts, which tell you to simply refuse to copy in such a
case.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2012-04-11 14:09:17
Subject: Re: 9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename
Previous:From: L'Huillier, JeffDate: 2012-04-11 13:54:31
Subject: 9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename

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