From: | "Bender, Cheryl" <cbender(at)mriresearch(dot)org> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Alternate db location |
Date: | 2004-09-07 23:09:59 |
Message-ID: | D5DB5D0D27171247AFEC9648EE98752F03220125@KCEX2KV1.mri-kc.int |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I apologize if this answer is in the archives but my search did not
reveal it.
I need to add an alternate db location for my 7.3.4 server (running on
FreeBSD 5.2 Release)
I thought I did everything according to the administrator's guide, but I
fail at createdb.
I completed the following:
-------
Shut down the server
Created the directory (/data/pgdata) and made pgsql the owner
I ran initlocation which created the base subdirectory. Everything
seemed fine.
Set the environment variable PGDATA2 to /data/pgdata
Restarted the server
Createdb (createdb -D PGDATA2 -U pgsql test) fails ("Postmaster
environment variable PGDATA2 not set" )
----------
Where I seem to be stumbling is getting Postmaster to recognize the
environment variable. Even if I do from the command line like this:
setenv PGDATA2 /data/pgdata
I still get "Postmaster environment variable PGDATA2 not set" when I try
to run createdb
I have tried every conceivable combination of user/setting
variable/running createdb (with quotes) but I just cannot seem to find
the right combo.
I have tried setting the variable in the startup script (that is
installed with the FreeBSD package) and restarting the server.
I have tried su'ing to pgsql and setting the variable as the pgsql user.
What does the postmaster desire that I have not fulfilled?????????
Cheryl Bender
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-09-07 23:21:50 | Re: Alternate db location |
Previous Message | Jerry LeVan | 2004-09-07 22:21:48 | Re: Selecting columns by position? |