pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedNEED REPLICATION SOLUTION -POSTGRES 9.1
3+ messages / 3 participants
[nested] [flat]
* NEED REPLICATION SOLUTION -POSTGRES 9.1
@ 2012-11-28 18:12 suhas.basavaraj12 <suhas.b@verse.in>
0 siblings, 2 replies; 3+ messages in thread
From: suhas.basavaraj12 @ 2012-11-28 18:12 UTC (permalink / raw)
To: pgsql-performance
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: NEED REPLICATION SOLUTION -POSTGRES 9.1
@ 2012-11-28 18:15 Claudio Freire <klaussfreire@gmail.com>
parent: suhas.basavaraj12 <suhas.b@verse.in>
1 sibling, 0 replies; 3+ messages in thread
From: Claudio Freire @ 2012-11-28 18:15 UTC (permalink / raw)
To: suhas.basavaraj12 <suhas.b@verse.in>; +Cc: 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.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: NEED REPLICATION SOLUTION -POSTGRES 9.1
@ 2012-11-28 18:30 Rick Otten <rotten@manta.com>
parent: suhas.basavaraj12 <suhas.b@verse.in>
1 sibling, 0 replies; 3+ messages in thread
From: Rick Otten @ 2012-11-28 18:30 UTC (permalink / raw)
To: pgsql-performance
I recommend SymmetricDS - http://www.symmetricds.org
-----Original Message-----
From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of suhas.basavaraj12
Sent: Wednesday, November 28, 2012 1:12 PM
To: pgsql-performance@postgresql.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-11-28 18:30 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-11-28 18:12 NEED REPLICATION SOLUTION -POSTGRES 9.1 suhas.basavaraj12 <suhas.b@verse.in>
2012-11-28 18:15 ` Claudio Freire <klaussfreire@gmail.com>
2012-11-28 18:30 ` Rick Otten <rotten@manta.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox