Re: Replication and PITR - Mailing list pgsql-general

From Bo Lorentsen
Subject Re: Replication and PITR
Date
Msg-id 45137B91.3070106@netgroup.dk
Whole thread Raw
In response to Re: Replication and PITR  (Chander Ganesan <chander@otg-nc.com>)
Responses Re: Replication and PITR  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Bo Lorentsen
Date:
Subject: Re: Replication and PITR
Next
From: Bo Lorentsen
Date:
Subject: Re: Replication and PITR