Re: Seeking datacenter PITR backup suggestions

[Decibel! <decibel(at)decibel(dot)org>]

On Tue, Aug 28, 2007 at 08:31:10PM +0100, Gregory Stark wrote:
> "Steve Crawford" <scrawford(at)pinpointresearch(dot)com> writes:
> 
> > 4. Much more up-to-the-minute recovery data.
> >
> > In your scenario, what about using "cp -l" (or "ln") instead? Since the
> > hard-link it is only creating a new pointer, it will be very fast and
> > save a bunch of disk IO on your server and it doesn't appear that the
> > tempdir is for much other than organizing purposes anyway.
> 
> Postgres tries to reuse WAL files. Once the archive_command completes it
> believes it is safe to reuse the old file without deleting it. That will do
> nasty things if you've used ln as your archive command.

I thought that was specifically disabled when PITR was enabled? Or do we
just do a rename rather than an unlink ond creating a new file?
-- 
Decibel!, aka Jim Nasby                        decibel(at)decibel(dot)org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Attachment: pgp2q31niYRFp.pgp
Description: PGP signature