[Pgcluster-general] newbie question

Fernando Reyes fernando_reyes at tutopia.com
Thu Aug 7 16:06:14 UTC 2008


Hi, i'm newbie in postgresql so maybe what i'm looking for doesn't exist 
or i'm doing wrong (//most likely), could you help me please...
I have 3 nodes configured as multi-master (all of them), so one can 
replicate to each other in normal state, but when i take one out of the 
group by unplugging the ethernet cable, the replication sequence is lost 
(every node is still working but not replicating) and i cannot restore 
the normal state without restarting each node, is that a normal behavior 
? is there a way to achieve the automatic sync of the pending data to 
every node in the group ?, look, the final idea is having 3 nodes with 
the same configuration (cluster-replicator) such a way we can connect, 
read and write data to any of them, and getting the same result (data) 
in any of them at any time, but when a node fails by a disconnection and 
the node can receive incoming connections from the client applications, 
but it's isolated from the other nodes,  the rest of the nodes stay 
working as if nothing happened, receiving incoming connections to read 
and write data and replicating it to the available nodes, and finally 
when the connection is restablished getting a full sync data over the 
entire group with the minimal lose of time (synchronizing just the 
pending data)... is that posible with pgcluster ?,

thanks in advance...
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: cluster1.conf
Url: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080807/443dd818/attachment.ksh 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: cluster2.conf
Url: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080807/443dd818/attachment-0001.ksh 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: cluster3.conf
Url: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080807/443dd818/attachment-0002.ksh 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: pglb1.conf
Url: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080807/443dd818/attachment-0003.ksh 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: pglb2.conf
Url: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080807/443dd818/attachment-0004.ksh 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: pglb3.conf
Url: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080807/443dd818/attachment-0005.ksh 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: pgreplicate1.conf
Url: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080807/443dd818/attachment-0006.ksh 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: pgreplicate2.conf
Url: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080807/443dd818/attachment-0007.ksh 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: pgreplicate3.conf
Url: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080807/443dd818/attachment-0008.ksh 


More information about the Pgcluster-general mailing list