| From: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
|---|---|
| To: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Read-only availability of a standby server? |
| Date: | 2008-01-03 01:04:39 |
| Message-ID: | 1199322279.4569.6.camel@neuromancer.home.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2007-11-21 at 15:33 -0500, Andrew Sullivan wrote:
> On Wed, Nov 21, 2007 at 12:20:51PM -0800, Garber, Mikhail wrote:
>
> > In the high-availabilty situation with a warm standby, is it possible (or
> > planned) to be able to make standby readable?
>
> Yes, but it won't happen for 8.3. It's a feature you can have today with
> Slony, by the way.
Slony provides the _means_ for it to be a standby-read-only server, but
it _does_ not provide a way for load balancing the queries, (which is
what I really want anyway) The only way to do that is through another
app like LVS / pgpool or even coding it directly into the frontend app.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ow Mun Heng | 2008-01-03 03:15:23 | [OT] Slony (initial) Replication - Slow |
| Previous Message | Ow Mun Heng | 2008-01-03 01:02:36 | Re: replication in Postgres |