Re: NEED REPLICATION SOLUTION -POSTGRES 9.1

From: Rick Otten <rotten(at)manta(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: NEED REPLICATION SOLUTION -POSTGRES 9.1
Date: 2012-11-28 18:30:20
Message-ID: 362605510214004CB3313A03D3D697DE7EAFE38A@cmhvm005
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I recommend SymmetricDS - http://www.symmetricds.org

-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of suhas.basavaraj12
Sent: Wednesday, November 28, 2012 1:12 PM
To: pgsql-performance(at)postgresql(dot)org
Subject: [PERFORM] NEED REPLICATION SOLUTION -POSTGRES 9.1

Hi,

We are planning to migrate our production databases to different servers.We have around 8 servers with 8 different clusters.We are planning t shuffle databases and make them as 7 cluster and migrate to new remote servers .
We cannot use streaming replication as we are migrating different databases from different clusters to one single cluster . This will be resulting in huge downtime as data is huge .
Need expert advice on this scenario.Can we reduce downtime in any way ..??

Rgrds
Suhas

--
View this message in context: http://postgresql.1045698.n5.nabble.com/NEED-REPLICATION-SOLUTION-POSTGRES-9-1-tp5733939.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

--
Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message John Lister 2012-11-28 18:37:32 Comparative tps question
Previous Message Claudio Freire 2012-11-28 18:15:33 Re: NEED REPLICATION SOLUTION -POSTGRES 9.1