Re: Replication and PITR - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Replication and PITR
Date
Msg-id 20060926153502.GD13326@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Replication and PITR  (Bo Lorentsen <bl@netgroup.dk>)
List pgsql-general
On Fri, Sep 22, 2006 at 07:58:41AM +0200, Bo Lorentsen wrote:
> Interesting note ... do you know how fare PG would be from being able to
> be in "read-only" state when receiving PITR data ? Is it a complex
> problem or a simple one to solve ?

I don't know that it's even possible.  The PITR replica is
essentially a node in permanent crash-recovery mode until it's caught
up.  Think of Oracle's comparable product -- you can't read from
those replicas either.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
If they don't do anything, we don't need their acronym.
        --Josh Hamilton, on the US FEMA

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Good books about PL/PGSQL programming?
Next
From: Andrew Sullivan
Date:
Subject: Re: Replication and PITR