From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | Neil Worden <nworden1234(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: naming of wal-archives |
Date: | 2013-01-30 23:13:36 |
Message-ID: | 5109A920.9050501@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 01/30/2013 11:16 AM, Jeff Janes wrote:
> On Wed, Jan 30, 2013 at 12:58 AM, Neil Worden <nworden1234(at)gmail(dot)com> wrote:
>
>
>> If not, how do i prevent files from being overwritten when using an
>> archive_command ?
>
> It is the archive_command's job to refuse to overwrite. From the docs:
>
> "It is advisable to test your proposed archive command to ensure that
> it indeed does not overwrite an existing file, and that it returns
> nonzero status in this case"
>
> Hopefully you have done this, otherwise bad things may happen when the
> 6D line collides with the 8D line.
>
> If your command does overwrite, then the server currently emitting the
> 8D files will become unrecoverable once those files start getting
> overwritten. If it refuses to overwrite, but returns a zero status,
> then the server currently emitting 6D would become unrecoverable once
> it reaches 8D and its "archived" files are not actually being archived
> but are getting deleted from the local pg_xlog anyway.
Would it not be easier to archive the different servers to different
directories and eliminate the possibility of name collision between servers?
> Cheers,
>
> Jeff
>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | deepak | 2013-01-30 23:20:12 | Version numbers for binaries |
Previous Message | Steve Crawford | 2013-01-30 22:48:54 | Re: psql question |