From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Alternate database locations |
Date: | 2002-02-19 03:42:50 |
Message-ID: | Pine.LNX.4.44.0202181937180.24052-100000@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
This came up back in the days of postgres-6.x and I was told that it would
be working in the 7.x series. I'm sure that it is, but I'm not doing
something correctly.
I want to set up a database in a directory other than
/var/lib/pgsql/data/, so in both postgres' ~/.bash_profile and my
~/.bash_profile I added the line:
PGDATA2="/opt/paisley/"; export PGDATA2
then I restarted the postmaster.
When I try to create a database there I get the message that the
postmaster doesn't know of that directory:
[rshepard(at)salmo ~]$ createdb --location=PGDATA2 --template=template1 paisley
ERROR: Postmaster environment variable 'PGDATA2' not set
createdb: database creation failed
What have I done incorrectly, please?
TIA,
Rich
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc. (TM)
2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
+ 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard(at)appl-ecosys(dot)com
http://www.appl-ecosys.com
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2002-02-19 04:04:01 | Re: Problem with unixODBC driver and lenth of sql statements |
Previous Message | Richard Emberson | 2002-02-19 03:33:30 | PL/pgsql UPDATE status |