On Wed, Dec 3, 2008 at 4:30 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Wed, Dec 3, 2008 at 2:29 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: >> On Wed, Dec 3, 2008 at 2:23 PM, Jaime Casanova >> <jcasanov@xxxxxxxxxxxxxxxxxxx> wrote: >>> 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? >> >> yes. > > even if it sends NO queries. just starting the second postmaster is enough > ok... actually i see no real value in that config (create a single point of contention) but everyone that has used (or at least read about) oracle think is the best thing to do... -- 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
