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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general