Thread: Table replication
Hi Members,
Is there any way to sync a single table across the DBs. We need a single table alone to be equal in all DBs in the single postgres. Presenly we are doing this with the help of Update, insert, delete trigger.
Is there any other best way for that.
Arvind S
Is there any way to sync a single table across the DBs. We need a single table alone to be equal in all DBs in the single postgres. Presenly we are doing this with the help of Update, insert, delete trigger.
Is there any other best way for that.
Arvind S
S Arvind wrote: > Hi Members, > Is there any way to sync a single table across the DBs. We need a single > table alone to be equal in all DBs in the single postgres. Presenly we are > doing this with the help of Update, insert, delete trigger. > Is there any other best way for that. Most trigger-based replication systems should work fine with one or more tables: slony, londiste etc. That's assuming a single master DB that receives all updates. -- Richard Huxton Archonet Ltd
On Jul 9, 7:53 pm, d...@archonet.com (Richard Huxton) wrote: > S Arvind wrote: > > Hi Members, > > Is there any way to sync a single table across the DBs. We need a single > > table alone to be equal in all DBs in the single postgres. Presenly we are > > doing this with the help of Update, insert, delete trigger. > > Is there any other best way for that. > > Most trigger-based replication systems should work fine with one or more > tables: slony, londiste etc. That's assuming a single master DB that > receives all updates. > > -- > Richard Huxton > Archonet Ltd > > -- > Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org) > To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general And tools like bucardo or rubyrep can do this in a master-master replication. Regards, Arndt Lehmann