Thread: 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-tp5733937.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
On Nov 28, 2012, at 11:06 AM, suhas.basavaraj12 wrote: > 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 scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice
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.
It's work perfect for me, async replication.
Gabriel.
On Wed, Nov 28, 2012 at 3:18 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
On Nov 28, 2012, at 11:06 AM, suhas.basavaraj12 wrote:You can use the Slony replication system: <http://slony.info/>
> Need expert advice on this scenario.Can we reduce downtime in any way ..??
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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 On Wed, Nov 28, 2012 at 1:46 PM, Gabriel Muñoz <gabriel.munoz@gmail.com> wrote: > 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. > > > > > On Wed, Nov 28, 2012 at 3:18 PM, Scott Ribe <scott_ribe@elevated-dev.com> > wrote: >> >> On Nov 28, 2012, at 11:06 AM, suhas.basavaraj12 wrote: >> >> > 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 >> scott_ribe@elevated-dev.com >> http://www.elevated-dev.com/ >> (303) 722-0567 voice >> >> >> >> >> >> >> -- >> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-admin > >