| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
| Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: two postgres server seeing the same data |
| Date: | 2008-12-03 17:43:24 |
| Message-ID: | 1228326204.27483.127.camel@jd-laptop.pragmaticzealot.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2008-12-03 at 12:29 -0500, Jaime Casanova wrote:
> Hi,
>
> a client of mine is obsessed with the idea of having two postgres
> servers looking at the same partition of data... i think i can
> configure two servers pointing to the same $PGDATADIR and let one off
> and the other on but is it possible for load balancing, i mean with
> the two servers active? obviously one of the two should be only for
> reading...
No.
You may have two servers pointed at $PGDATA but at no point can
postgresql be running on both at the same time.
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joey K. | 2008-12-03 18:00:17 | Switch off PITR |
| Previous Message | Dave Page | 2008-12-03 17:40:30 | Re: two postgres server seeing the same data |