Streaming replication info - Mailing list pgsql-general

From mephysto
Subject Streaming replication info
Date
Msg-id 1304925482143-4381239.post@n5.nabble.com
Whole thread Raw
Responses Re: Streaming replication info  (Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>)
List pgsql-general
Hi there,
I would to configure a multinode PostgreSQL system using streaming
replication. In my mind, I would have a base configuration with a master
node and more than one slaves in streaming replication.

I have no difficult to imagine start situation, but my problems come when
master fails: if my slaves receive strems from the master, when this fails
is there a manner to change connection_info in recovery.conf and change
server to a new master?

Is there a manner to reload recovery.conf without restart nodes?

Or the only solution of this situation is that all slaves became "masters"?

Thanks in advance.

Regards

Meph



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-replication-info-tp4381239p4381239.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Possible to replicate a single table with Pg 9.0.4?
Next
From: Jack Christensen
Date:
Subject: Re: Multiple table relationship constraints