Re: Running several postmaster using same database in parallel - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Running several postmaster using same database in parallel
Date
Msg-id Pine.LNX.4.21.0011231801250.1355-100000@peter.localdomain
Whole thread Raw
In response to Re: Running several postmaster using same database in parallel  (Steffen Schmidt <Steffen.Schmidt@EMBL-Heidelberg.de>)
List pgsql-general
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/


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: can't get user authentication to work - HELP!
Next
From: "Schmidt, Peter"
Date:
Subject: Hung backends