[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