Re: Replication and PITR

Chander Ganesan wrote:
> Keep in mind that while Slony-I provides you with a read-only replica
> (able to service queries).  At present WAL log replication (in 8.2 or
> otherwise) would allow you to have a 'warm standby' type database -
> which would be somewhat in sync (pending the latest transactions), but
> would be unable to service queries (essentially, you'd have a server
> that was sitting with postmaster in a recovery state).
>
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 ?

/BL