Re: archive_command - Mailing list pgsql-admin

From Jeff Frost
Subject Re: archive_command
Date
Msg-id Pine.LNX.4.63.0510012142210.13614@discord.dyndns.org
Whole thread Raw
In response to Re: archive_command  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: archive_command  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-admin
On Fri, 30 Sep 2005, Simon Riggs wrote:

> If I follow your example, yes. But that assumes there is only one
> timeline's WAL files in your pg_xlog. It could get more complex in that
> situation because you could be in any of the timelines.
>
> But, if you know which timeline you're in, then yes, the file after the
> latest file in archive_status is the current WAl file.
>
> It might be interesting to submit your script to put into contrib?

So, actually, my script is probably doing things incorrectly at the moment.
What effect would the different timelines create?  In my client's case there
is only one timeline, but I'd love to generalize the script so we can put it
in contrib, but first I'd like to make sure it actually works properly. :-)

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: archive_command
Next
From: Simon Riggs
Date:
Subject: Re: archive_command