On Wed, Dec 3, 2008 at 1:10 PM, Andrew Sullivan <ajs@xxxxxxxxxxxxxxx> wrote: > On Wed, Dec 03, 2008 at 09:43:24AM -0800, Joshua D. Drake wrote: >> You may have two servers pointed at $PGDATA but at no point can >> postgresql be running on both at the same time. > > More importantly, if you do this, you will probably be able to get the > two postmasters to start up. This will permanently corrupt the data. is this true even if one of the server just send SELECTs? > I know this partly because of experience with a "failover" system > whose interlocks failed. Two postmasters, one data area, and no > recoverable data. > the worst part of learning the lesson ;) -- 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
