Alternate db location
От | Bender, Cheryl |
---|---|
Тема | Alternate db location |
Дата | |
Msg-id | D5DB5D0D27171247AFEC9648EE98752F03220125@KCEX2KV1.mri-kc.int обсуждение исходный текст |
Ответы |
Re: Alternate db location
|
Список | 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
В списке pgsql-admin по дате отправления: