Re: [SQL] syncing - between databases

2012-05-14 Thread Devrim GÜNDÜZ
On Mon, 2012-05-14 at 17:25 +0530, Trinath Somanchi wrote: > True, But it has its own stable version capable to handle this > functionality PGCluster was not a stable project. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant,

Re: [SQL] syncing - between databases

2012-05-14 Thread Trinath Somanchi
True, But it has its own stable version capable to handle this functionality On Mon, May 14, 2012 at 5:23 PM, Devrim GÜNDÜZ wrote: > On Mon, 2012-05-14 at 17:22 +0530, Trinath Somanchi wrote: > > You can use PgCluster with Slony-II for this type of requirements. > > PGCluster is a dead project.

Re: [SQL] syncing - between databases

2012-05-14 Thread Devrim GÜNDÜZ
On Mon, 2012-05-14 at 17:22 +0530, Trinath Somanchi wrote: > You can use PgCluster with Slony-II for this type of requirements. PGCluster is a dead project. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified E

Re: [SQL] syncing - between databases

2012-05-14 Thread Trinath Somanchi
Hi- You can use PgCluster with Slony-II for this type of requirements. On Mon, May 14, 2012 at 11:02 AM, Steven Crandell wrote: > Having all the dblink destinations on the same server makes it a much more > viable option since the chances of the dblink update failing are greatly > reduced.

Re: [SQL] syncing - between databases

2012-05-13 Thread Steven Crandell
Having all the dblink destinations on the same server makes it a much more viable option since the chances of the dblink update failing are greatly reduced. That said, here's a run down on the queue system I described with some specificity toward your situation. You can add a flag to each custome

Re: [SQL] syncing - between databases

2012-05-13 Thread John Fabiani
All on the same cluster (only one server). Although, it would be nice to have only one table there are real business reasons to dup the databases. I am interested in how you dealt with a queue table. Would you take a little time to describe the way it worked. Johnf On Saturday, May 12, 2012

Re: [SQL] syncing - between databases

2012-05-12 Thread Steven Crandell
Are these 5 databases on different servers and at different locations or are they on the same local cluster? If they are all on the same local cluster you may want to rethink how you are storing customer data. The design you describe seems redundant. If you are dealing with multiple servers (and