Re: [GENERAL] Table replication

2009-07-09 Thread Arndt Lehmann
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

Re: [GENERAL] Table replication

2009-07-09 Thread Richard Huxton
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

Re: [GENERAL] table replication, without master-slave setup

2006-07-17 Thread Csaba Nagy
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

Re: [GENERAL] table replication, without master-slave setup

2006-07-14 Thread Shoaib Mir
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