Re: Running several postmaster using same database in parallel

Steffen Schmidt writes:

> > > I'am running several postmaster on different machines, accessing the
> > > same database in parallel. Is this a good idea?
> >
> > Not at all. In fact, version 7.0 and later won't even let you do this any
> > more. Earlier versions where not so careful.
>
> Well, I am running postmasters in parallel using postgres-7.0.2. So
> postgres let me do this...???

Well, since you are running on separate hosts the postmaster you start up
second will find the pid lock file, determine that there's no process with
that pid (on its machine) and delete it. So I guess you can do it, but
that still doesn't mean that your data is going to survive this.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/