Alternate db location

Поиск
Список
Период
Сортировка
От Bender, Cheryl
Тема Alternate db location
Дата
Msg-id D5DB5D0D27171247AFEC9648EE98752F03220125@KCEX2KV1.mri-kc.int
обсуждение исходный текст
Ответы Re: Alternate db location  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] TOAST tables, cannot truncate
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Alternate db location