Warm standby: 1 to N - Mailing list pgsql-general

From Yaroslav Tykhiy
Subject Warm standby: 1 to N
Date
Msg-id 4A0B62B5.4060904@barnet.com.au
Whole thread Raw
Responses Re: Warm standby: 1 to N  (Bruce Momjian <bruce@momjian.us>)
List 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

pgsql-general by date:

Previous
From: "Andrew Maclean"
Date:
Subject: Re: postgres 3.7 unexpected closing of connections
Next
From: Andrew Maclean
Date:
Subject: Re: postgres 3.7 unexpected closing of connections