Thread: More on creating data bases for 4 distinct users

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?

Thanks for any pointers ...

"George"


--
G. Walsh,
DSC Directional Services Corp.,
#507 890 Academy Close,
Victoria, B.C. V8V 2Y1

(250) 386-4498

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