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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026