Re: NEED REPLICATION SOLUTION -POSTGRES 9.1 - Mailing list pgsql-admin

From Robert Treat
Subject Re: NEED REPLICATION SOLUTION -POSTGRES 9.1
Date
Msg-id CABV9wwOMt=i2WY3v2J1V6NzqaCxJs4e2JO-Daj8HhtzxgEFuSg@mail.gmail.com
Whole thread Raw
In response to Re: NEED REPLICATION SOLUTION -POSTGRES 9.1  (Gabriel Muñoz <gabriel.munoz@gmail.com>)
List 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
>
>


pgsql-admin by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Fwd: Monitoring Replication on Master/Slave Postgres(9.1)
Next
From: Shams Khan
Date:
Subject: Re: Fwd: Monitoring Replication on Master/Slave Postgres(9.1)