Discussion:
NEED REPLICATION SOLUTION -POSTGRES 9.1
(too old to reply)
suhas.basavaraj12
2012-11-28 18:06:45 UTC
Permalink
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-tp5733937.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Scott Ribe
2012-11-28 18:18:55 UTC
Permalink
Post by suhas.basavaraj12
Need expert advice on this scenario.Can we reduce downtime in any way ..??
You can use the Slony replication system: <http://slony.info/>
--
Scott Ribe
***@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Gabriel Muñoz
2012-11-28 18:46:07 UTC
Permalink
I'm using WAL, I follow this tutorial:
http://blog.gomiso.com/2012/02/13/adventures-in-scaling-part-3-postgresql-streaming-replication/

It's work perfect for me, async replication.

Gabriel.
Post by Scott Ribe
Post by suhas.basavaraj12
Need expert advice on this scenario.Can we reduce downtime in any way
..??
You can use the Slony replication system: <http://slony.info/>
--
Scott Ribe
http://www.elevated-dev.com/
(303) 722-0567 voice
--
http://www.postgresql.org/mailpref/pgsql-admin
Robert Treat
2012-11-28 19:07:29 UTC
Permalink
The OP mentioned he couldn't use streaming as he is combining
databases from multiple clusters into one, so non-streaming WAL isn't
going to work any better for that.

He needs to use Slony, Bucardo, or some other trigger based system (or
roll his own) to accomplish this, WAL based solutions wont work.


Robert Treat
play: xzilla.net
work: omniti.com
Post by Gabriel Muñoz
http://blog.gomiso.com/2012/02/13/adventures-in-scaling-part-3-postgresql-streaming-replication/
It's work perfect for me, async replication.
Gabriel.
Post by Scott Ribe
Post by suhas.basavaraj12
Need expert advice on this scenario.Can we reduce downtime in any way ..??
You can use the Slony replication system: <http://slony.info/>
--
Scott Ribe
http://www.elevated-dev.com/
(303) 722-0567 voice
--
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Loading...