Re: NEED REPLICATION SOLUTION -POSTGRES 9.1 - Mailing list pgsql-performance

From Claudio Freire
Subject Re: NEED REPLICATION SOLUTION -POSTGRES 9.1
Date
Msg-id CAGTBQpYMxvKdmFq5EJj0WMqbYdjZwPvM=Vy1A5zba3yYnj88Cw@mail.gmail.com
Whole thread Raw
In response to NEED REPLICATION SOLUTION -POSTGRES 9.1  ("suhas.basavaraj12" <suhas.b@verse.in>)
List pgsql-performance
On Wed, Nov 28, 2012 at 3:12 PM, suhas.basavaraj12 <suhas.b@verse.in> wrote:
> 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 ..??

One time we had to do something like this (on a smaller scale), we used slony.


pgsql-performance by date:

Previous
From: "suhas.basavaraj12"
Date:
Subject: NEED REPLICATION SOLUTION -POSTGRES 9.1
Next
From: Rick Otten
Date:
Subject: Re: NEED REPLICATION SOLUTION -POSTGRES 9.1