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
>
>
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) |