| From: | Claudio Freire <klaussfreire(at)gmail(dot)com> |
|---|---|
| To: | "suhas(dot)basavaraj12" <suhas(dot)b(at)verse(dot)in> |
| Cc: | postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: NEED REPLICATION SOLUTION -POSTGRES 9.1 |
| Date: | 2012-11-28 18:15:33 |
| Message-ID: | CAGTBQpYMxvKdmFq5EJj0WMqbYdjZwPvM=Vy1A5zba3yYnj88Cw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Nov 28, 2012 at 3:12 PM, suhas.basavaraj12 <suhas(dot)b(at)verse(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rick Otten | 2012-11-28 18:30:20 | Re: NEED REPLICATION SOLUTION -POSTGRES 9.1 |
| Previous Message | suhas.basavaraj12 | 2012-11-28 18:12:27 | NEED REPLICATION SOLUTION -POSTGRES 9.1 |