Thread: Quickie about Database locations

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Gareth Kirwan
Sent: 22 October 2002 16:14
To: pgsql-admin@postgresql.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@thermeoneurope.com
Tel: +44 (0) 1293 864 303
Thermeon Europe e-Card: gbjk

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