From: | "Gareth Kirwan" <gbjk(at)thermeoneurope(dot)com> |
---|---|
To: | <gbjk(at)thermeoneurope(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Quickie about Database locations |
Date: | 2002-10-22 15:19:08 |
Message-ID: | KMEELFAKJGHIGGNIDGHDKEPKJOAA.gbjk@thermeoneurope.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Gareth StationeryQuick response too:
Shortly after sending the email I tried exactly what I said, with the
following alteration:
I put the lines in the .bash_profile first, then initlocation'd then I
exited and restarted postgres,
then I su'd back in - and tried the create - and bingo - it worked.
Sorry if I wasted anyone's time :-)
Regards
Gareth Kirwan
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Gareth Kirwan
Sent: 22 October 2002 16:14
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Quickie about Database locations
Hey all!
I'm muddled up about something.
I'm creating a new database, and absolute paths are disallowed.
Therefore I su to postgres ( the owner of the service ) and run the
following:
export PGDATA2=/bla/bla/bla
initlocation PGDATA2
initlocation returns fine - telling me to create the database as per
usual.
I therefore do:
createdb v2 -D 'PGDATA2'
But I get:
ERROR: Postmaster environment variable 'PGDATA2' not set
createdb: database creation failed
I echo it - to test it - it works.
I put it in the bash_profile of the user, restart postgres... nothing...
Any ideas?
Thanks everyone
Gareth Kirwan
Programming & Development,
Thermeon Europe Ltd,
gbjk(at)thermeoneurope(dot)com
Tel: +44 (0) 1293 864 303
Thermeon Europe e-Card: gbjk
From | Date | Subject | |
---|---|---|---|
Next Message | Nicholas Barthelemy | 2002-10-22 15:25:57 | 7.2 date/time format function problems |
Previous Message | Gareth Kirwan | 2002-10-22 15:14:09 | Quickie about Database locations |