Re: More on creating data bases for 4 distinct users

G. Walsh wrote:
> Further to my earlier posting, I have now figured out that I have to
> create clusters for each of the users in their own directory structures.
> I have done that, and made all files owned by the development user id as
> well as identifying that user to postgres.
>
> That takes me to the problem of triggering multiple postmasters at
> bootup. I cannot accomplish this in the furnished
> /etc/rc.d/init.d/postgresql script which makes explicit mention of the
> fact this is not yet provided for.
>
> Is anyone else doing this?
>
> My reasons for doing so are twofold:
>
> One, I want to spread the activity in an array of fast SCSI hard drives
> and
>
> Two, I need to be able to easily extricate each of the sites
> individually as the time comes for each to be transferred from the
> development machine to a co-location machine.
>
> Could I, for example, add the additional postmaster requests to the
> existing .opt file in postgres' default directory?

You can do this by starting multiple postmaster and having each one
listen on a distinct port number.  The documentation covers this.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073