| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Replication and PITR |
| Date: | 2006-09-26 15:35:02 |
| Message-ID: | 20060926153502.GD13326@phlogiston.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)crankycanuck(dot)ca
If they don't do anything, we don't need their acronym.
--Josh Hamilton, on the US FEMA
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2006-09-26 15:45:50 | Re: Replication and PITR |
| Previous Message | Andrew Sullivan | 2006-09-26 15:32:42 | Re: Good books about PL/PGSQL programming? |