From: | "Brian C(dot) Doyle" <bcdoyle(at)mindspring(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Alternate Database Locations |
Date: | 2000-10-26 14:56:05 |
Message-ID: | 5.0.0.25.2.20001026105038.054c5a90@pop.mindspring.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Okay...
I can now run as many postmasters as I could imagine... KICK BUTT!!!!
I am still running into a problem with the "alternate database
locations" and that is I seem to be able to only set up 1 other alternate
location.
After getting the first alt location setup Iset PGDATA2= /home/user1/database
export it
initdb -D /home/user1/database
started postmaster -D /home/user1/database
initlocation 'PGDATA2'
createdb user1 -D 'PGDATA2'
it creates but it is putting it in /home/user/database
the first alt location i set up!!!
I know I am being a pain in the ass but I truly do appreciate all the help
At 10:02 AM 10/26/00 -0400, Tom Lane wrote:
>"Brian C. Doyle" <bcdoyle(at)mindspring(dot)com> writes:
> > Okay I am still doing something wrong here
> > I set PGDATA2=/home/user1/database
> > export PGDATA2
>
> > then I start postmaster
> > postmaster -d PGDATA2 -i -p 5431 &
>
>I think you are confusing the "alternate database directory" stuff with
>having a separate installation (primary directory). To set up a second
>postmaster, you first have to initdb its installation directory:
>
> initdb -D /home/user1/database
>
>then start the postmaster like so:
>
> postmaster -D /home/user1/database -p whatever ...
>
>Instead of -D (note upper case), you can alternatively set env variable
>PGDATA for these two programs.
>
>The stuff in the manual about alternate database directories is to allow
>a *single* postmaster to manage databases located somewhere other than
>underneath its installation directory. It's got nothing at all to do
>with starting additional postmasters.
>
> regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-10-26 15:00:24 | Re: [SQL] pg_atoi: error in "template1": can't parse "template1" |
Previous Message | Pitot | 2000-10-26 14:53:15 | Nested Aggregate fonction & gouping attributes |