Re: [ADMIN] Question about multiple postmasters

> > > 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