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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
