Thread: 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...???
On Thu, 23 Nov 2000, Steffen Schmidt wrote:
> > 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...???
What is the point? If they are all going back to the same database, you
can cut out some overhead and connect directly to the database to the
single postmaster running.
Brett W. McCoy
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
A woman has got to love a bad man once or twice in her life to be
thankful for a good one.
-- Marjorie Kinnan Rawlings
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@gmx.net http://yi.org/peter-e/