Search Postgresql Archives

two postgres server seeing the same data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux