Re: Replication and PITR

[Bo Lorentsen <bl@xxxxxxxxxxx>]

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