Re: Replication and PITR

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