| From: | "Dave Page" <dpage(at)pgadmin(dot)org> |
|---|---|
| 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:40:30 |
| Message-ID: | 937d27e10812030940g178b9998n15af4cdd3acdfd84@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Dec 3, 2008 at 5:29 PM, Jaime Casanova
<jcasanov(at)systemguards(dot)com(dot)ec> 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...
It won't work, and will (if you even manage to get the second server
to start) cause all manner of pain and suffering.
Look for a different solution (Slony? Bucardo?)
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2008-12-03 17:43:24 | Re: two postgres server seeing the same data |
| Previous Message | Jaime Casanova | 2008-12-03 17:29:44 | two postgres server seeing the same data |