| From: | "Igor Georgiev" <gory(at)alphasoft-bg(dot)com> |
|---|---|
| To: | <gbjk(at)thermeoneurope(dot)com> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Quickie about Database locations |
| Date: | 2002-10-22 16:19:32 |
| Message-ID: | 010301c279e6$cf722b00$0b0546c0@alpha.bg |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Gareth StationeryHey 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
********
export PGDATA2=/bla/bla/bla ...
how about restart postmaster ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Georgiev | 2002-10-22 16:34:57 | Re: Security question : Database access control |
| Previous Message | Igor Georgiev | 2002-10-22 16:12:16 | Re: Security question : Database access control |