Re: [GENERAL] Warm Standby and resetting the primary as a standby

2010-08-23 Thread Tom Lane
Derrick Rice writes: > Is it possible to interpret the requested file and ignore the timeline > digits and provide a file from some other timeline? Or is the timeline mean > more than just the file name? Sounds dangerous as can be to me. The point of the timeline stuff is that a particular rang

Re: [GENERAL] Warm Standby and resetting the primary as a standby

2010-08-23 Thread Bruce Momjian
Derrick Rice wrote: > On Mon, Aug 23, 2010 at 5:45 PM, Bruce Momjian wrote: > > > > > > > Sorry, I don't know. I think the timelines are only there for safety if > > you have to fall back to the previous timeline, and to prevent timeline > > mixing. > > > Thanks for the helpful answers. > > T

Re: [GENERAL] Warm Standby and resetting the primary as a standby

2010-08-23 Thread Derrick Rice
On Mon, Aug 23, 2010 at 5:45 PM, Bruce Momjian wrote: > > > Sorry, I don't know. I think the timelines are only there for safety if > you have to fall back to the previous timeline, and to prevent timeline > mixing. Thanks for the helpful answers. Two follow up questions which, if they can be

Re: [GENERAL] Warm Standby and resetting the primary as a standby

2010-08-23 Thread Bruce Momjian
Yaroslav Tykhiy wrote: > On Sat, Aug 21, 2010 at 12:45:44PM -0400, Bruce Momjian wrote: > > Derrick Rice wrote: > > > I've been reading up on the documentation for WAL shipping and warm > > > standby > > > configuration. One concern that I have (a common one, I'm sure) is that it > > > seems that

Re: [GENERAL] Warm Standby and resetting the primary as a standby

2010-08-22 Thread Yaroslav Tykhiy
On Sat, Aug 21, 2010 at 12:45:44PM -0400, Bruce Momjian wrote: > Derrick Rice wrote: > > I've been reading up on the documentation for WAL shipping and warm standby > > configuration. One concern that I have (a common one, I'm sure) is that it > > seems that after bringing a standby server up as pr

Re: [GENERAL] Warm Standby and resetting the primary as a standby

2010-08-21 Thread Bruce Momjian
Derrick Rice wrote: > I've been reading up on the documentation for WAL shipping and warm standby > configuration. One concern that I have (a common one, I'm sure) is that it > seems that after bringing a standby server up as primary, other standby > servers (including the original primary) need to

Re: [GENERAL] Warm Standby and resetting the primary as a standby

2010-08-19 Thread Derrick Rice
On Wed, Aug 18, 2010 at 9:48 AM, Derrick Rice wrote: > I've been reading up on the documentation for WAL shipping and warm standby > configuration. One concern that I have (a common one, I'm sure) is that it > seems that after bringing a standby server up as primary, other standby > servers (inclu

[GENERAL] Warm Standby and resetting the primary as a standby

2010-08-18 Thread Derrick Rice
I've been reading up on the documentation for WAL shipping and warm standby configuration. One concern that I have (a common one, I'm sure) is that it seems that after bringing a standby server up as primary, other standby servers (including the original primary) need to be rebased before they can