[ADMIN] Question about multiple slaves and Master loss.

2011-12-07 Thread Chris Hoover
I'm pretty sure that the answer to this question is no, but I wanted to verify. Given the following scenario (pg 9.0): Server A (Master), Server B (A's streaming replication Slave), Server C (A's streaming replication Slave) If you lose Server A, is there anyway to promote Server B to master

Re: [ADMIN] Question about multiple slaves and Master loss.

2011-12-07 Thread Nicholson, Brad (Toronto, ON, CA)
From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Chris Hoover Sent: Wednesday, December 07, 2011 12:05 PM To: pgsql-admin@postgresql.org Admin Subject: [ADMIN] Question about multiple slaves and Master loss. I'm pretty sure that the answer

Re: [ADMIN] Question about multiple slaves and Master loss.

2011-12-07 Thread Evan Rempel
, ON, CA) wrote: *From:* pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] *On Behalf Of *Chris Hoover *Sent:* Wednesday, December 07, 2011 12:05 PM *To:* pgsql-admin@postgresql.org Admin *Subject:* [ADMIN] Question about multiple slaves and Master loss. I'm pretty sure

Re: [ADMIN] Question about multiple slaves and Master loss.

2011-12-07 Thread Nicholson, Brad (Toronto, ON, CA)
-Original Message- From: Evan Rempel [mailto:erem...@uvic.ca] Sent: Wednesday, December 07, 2011 1:12 PM To: Nicholson, Brad (Toronto, ON, CA) Cc: Chris Hoover; pgsql-admin@postgresql.org Admin Subject: Re: [ADMIN] Question about multiple slaves and Master loss. Can you have