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
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
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
Hello,
I have a certain setup, so that two computers are running nearly
identical databases: identical setup, tables, users and permissions,
only the contents differ. Now I'd like to keep them in sync, WITHOUT an
extra machine, hence master-slave setup. The problem is, that either one
could fail e
