From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "G(dot) Walsh" <gwalsh(at)dscdirectionalservices(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: More on creating data bases for 4 distinct users |
Date: | 2004-01-04 04:45:17 |
Message-ID: | 200401040445.i044jHC05443@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | gavaneh | 2004-01-04 06:27:47 | problem with connecting to postgresql server |
Previous Message | Bruce Momjian | 2004-01-04 04:44:16 | Re: Creating initial data bases |