| From: | "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec> |
|---|---|
| To: | "Postgres general mailing list" <pgsql-general(at)postgresql(dot)org> |
| Subject: | two postgres server seeing the same data |
| Date: | 2008-12-03 17:29:44 |
| Message-ID: | 3073cc9b0812030929p1bc11b77u186585f33c6901fd@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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...
my thought is that it's not that beneficial because there will be the
same set of disks (even being an storage) and i'm not sure is at all
possible because the contents of shared memory in both servers will be
different...
thoughts? any one has tried that configuration?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2008-12-03 17:40:30 | Re: two postgres server seeing the same data |
| Previous Message | Bill Moran | 2008-12-03 17:00:23 | Re: restored over postgres database |