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
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
Alex,
If you have 2 different sets of data, you might want to replicate both
ways in separate data bases. I mean set up on both machines 2 data
bases, one master and one slave on both machines. Then you can use 2
slony replication sets to replicate in both directions. This way if one
of the server
You can use 'pgpool' (http://pgpool.projects.postgresql.org/) for that purpose.Shoaib MirEnterpriseDBOn 7/14/06,
Alexander Bluem <[EMAIL PROTECTED]> wrote:
Hello,I have a certain setup, so that two computers are running nearlyidentical databases: identical setup, tables, users and permissions,only