| From: | Bo Lorentsen <bl(at)netgroup(dot)dk> |
|---|---|
| To: | Chander Ganesan <chander(at)otg-nc(dot)com> |
| Cc: | Csaba Nagy <nagy(at)ecircle-ag(dot)com>, Bill Moran <wmoran(at)collaborativefusion(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Replication and PITR |
| Date: | 2006-09-22 05:58:41 |
| Message-ID: | 45137B91.3070106@netgroup.dk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alain Roger | 2006-09-22 05:58:56 | Backup / export DB |
| Previous Message | Bo Lorentsen | 2006-09-22 05:53:48 | Re: Replication and PITR |