Streaming replication info
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.
Hi,
Il 09/05/11 09:18, mephysto ha scritto:
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.
Cool.
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?
I suggest that you look at repmgr, an open-source tool for managing
replication the we are currently writing
(http://projects.2ndquadrant.com/repmgr) which should make this kind of
things much easier for you.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it