Warm standby: 1 to N

From: Yaroslav Tykhiy <yar(at)barnet(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Warm standby: 1 to N
Date: 2009-05-14 00:15:49
Message-ID: 4A0B62B5.4060904@barnet.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

Let's consider the following case: WAL segments from a master have
been shipped to N warm standby servers, and now the master fails.
Using this or that mechanism, one of the warm standbys takes over and
becomes the new master. Now the question is what to do with the other
N-1 warm standbys. By the failure, all N warm standbys were the same
exact copies of the master. So at least in theory, the N-1 warm
standbys left can be fed with WAL segments from the new master. Do
you think it will work in practice? Are there any pitfalls?

Thanks!

Yar

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Maclean 2009-05-14 00:34:20 Re: postgres 3.7 unexpected closing of connections
Previous Message Andrew Maclean 2009-05-13 23:57:18 Re: postgres 3.7 unexpected closing of connections