Re: NEED REPLICATION SOLUTION -POSTGRES 9.1

From: Robert Treat <rob(at)xzilla(dot)net>
To: Gabriel Muñoz <gabriel(dot)munoz(at)gmail(dot)com>
Cc: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, "suhas(dot)basavaraj12" <suhas(dot)b(at)verse(dot)in>, pgsql-admin(at)postgresql(dot)org
Subject: Re: NEED REPLICATION SOLUTION -POSTGRES 9.1
Date: 2012-11-28 19:07:29
Message-ID: CABV9wwOMt=i2WY3v2J1V6NzqaCxJs4e2JO-Daj8HhtzxgEFuSg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)munoz(at)gmail(dot)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(at)elevated-dev(dot)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(at)elevated-dev(dot)com
>> http://www.elevated-dev.com/
>> (303) 722-0567 voice
>>
>>
>>
>>
>>
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Shams Khan 2012-11-28 19:24:57 Re: Fwd: Monitoring Replication on Master/Slave Postgres(9.1)
Previous Message Steve Crawford 2012-11-28 19:02:26 Re: Fwd: Monitoring Replication on Master/Slave Postgres(9.1)