On Tue, Aug 28, 2007 at 08:31:10PM +0100, Gregory Stark wrote: > "Steve Crawford" <scrawford@xxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Attachment:
pgpdNAtsOJBie.pgp
Description: PGP signature
