Re: [ADMIN] Question about multiple postmasters - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: [ADMIN] Question about multiple postmasters
Date
Msg-id 199810020215.WAA23234@candle.pha.pa.us
Whole thread Raw
In response to RE: [ADMIN] Question about multiple postmasters  ("Jackson, DeJuan" <djackson@cpsgroup.com>)
Responses Re: [ADMIN] Question about multiple postmasters
List pgsql-admin
> > > Has anyone tried running multiple postmasters w/ the same data
> > > directory.
> > > Any issues to watch out for?  Problems with locking?
> > > All of the systems would be running on Red Hat 5.1 x86.
> >
> > Hard to imagine why you would want to do that.  pg_log would be shared
> > by all backends, even if they connect to different databases, so this
> > is
> > very bad.
> Where is the pg_log located?  The only thing they would share would be
> data directories.  I plan on running each backing on different machines
> sharing a data directory.  It's more for load distribution than anything
> else.

It will not work.  pg_log is in the toplevel data directory, and some of
the stuff is stored in shared memory, which is not shared among
postmasters.


--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026


pgsql-admin by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [ADMIN] Question about multiple postmasters
Next
From: "Sejin Oh"
Date:
Subject: Re: [ADMIN] Question about multiple postmasters