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 after bringing

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 br...@momjian.us 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

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 br...@momjian.us 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.

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

2010-08-23 Thread Tom Lane
Derrick Rice derrick.r...@gmail.com 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

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 primary,

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 be

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 derrick.r...@gmail.comwrote: 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

[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