From: | Selva manickaraja <mavles78(at)gmail(dot)com> |
---|---|
To: | Scott Mead <scottm(at)openscg(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Cascading Recovery |
Date: | 2011-02-14 02:54:32 |
Message-ID: | AANLkTin9KivbmWhCXTNThvLwh77Y351L0VZcwRJLpXQp@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thank you for the info.
On Mon, Feb 14, 2011 at 5:53 AM, Scott Mead <scottm(at)openscg(dot)com> wrote:
>
>
> On Sun, Feb 13, 2011 at 10:35 AM, Selva manickaraja <mavles78(at)gmail(dot)com>wrote:
>
>> Any updates?
>
>
> You can't use any wal based replication like that. When a node is in
> recovery mode, it doesn't log.
>
> --Scottie
>
>
>>
>>
>> ---------- Forwarded message ----------
>> From: Selva manickaraja <mavles78(at)gmail(dot)com>
>> Date: Sat, Feb 12, 2011 at 1:43 AM
>> Subject: Re: [ADMIN] Cascading Recovery
>> To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
>> Cc: pgsql-admin(at)postgresql(dot)org
>>
>>
>> If not with Streaming Replication, what about Continous Archiving Mode?
>>
>>
>> On Fri, Feb 11, 2011 at 3:35 PM, Guillaume Lelarge <
>> guillaume(at)lelarge(dot)info> wrote:
>>
>>> Le 11/02/2011 05:43, Selva manickaraja a écrit :
>>> > We are considering on using a primary and 2 secondary machines. But our
>>> plan
>>> > is to cascade the recovery as follows:
>>> >
>>> > 1. Primary Machine-A (read and write operation)
>>> > 2. Secondary Machine-B (recover from Machine A)
>>> > 3. Secondary Machine-C (recover from Machine B)
>>> >
>>> > We are planning this kind of recovery as we want to phase out recovery
>>> > interval between C and B 30 minutes.
>>> >
>>> > Can this be achieved by PostgreSQL.
>>> >
>>>
>>> Not with Streaming Replication. But you can achieve this with a
>>> different replication engine, like Slony.
>>>
>>>
>>> --
>>> Guillaume
>>> http://www.postgresql.fr
>>> http://dalibo.com
>>>
>>
>>
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2011-02-14 03:05:32 | Re: how do you manage postgres 9's postgres process's memory |
Previous Message | Scott Mead | 2011-02-13 21:53:06 | Re: Cascading Recovery |