Alternate db location

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

Responses

Browse pgsql-admin by date

  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?