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.mu...@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_r...@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_r...@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 > > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
