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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

G. Walsh wrote:
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 (AT) candle (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match