Re: [Pgreplication-general] converting the DBMirror as peer-to-peer

Where are we on this?  Is it something that can be added to dbmirror as
a patch?

---------------------------------------------------------------------------

merino silva wrote:
> Hi all,
> 
> The method I've used to convert DBMirror to a
> peer-to-peer replicator was two DBMirror instances
> with one considered slave of other as the master.
> 
> Here, I've stopped the loop back by dropping the
> trigger when INSERT, DELETE, UPDATE through the
> DBMirror and then creating the trigger again.
> 
> The system was tested on the
> ManddrakeLinux 9.2
> Posgresql 7.3.4
> and Perl v5.8.1
> 
> A 'LOCK TABLE <table name> IN EXCLUSIVE MODE'
> was used before dropping the trigger to prevent
> updating the client database, because updates for that
> database wont trigger to the remaining one while the
> trigger is dropped.
> 
> The modified DBMirror.pl is attached with this.
> 
> Is this an acceptable solution for peer-to-peer
> replication?
> What can be go wrong with this approach?
> 
> Please reply me with your suggestions.
> 
> regards,
> merino silva.
> 
> __________________________________
> Do you Yahoo!?
> Get better spam protection with Yahoo! Mail.
> http://antispam.yahoo.com/tools

Content-Description: DBMirror.pl

[ Attachment, skipping... ]

> _______________________________________________
> Pgreplication-general mailing list
> Pgreplication-general@gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pgreplication-general

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073