From: | Lendvary Gyorgy <gyurika(at)prolan(dot)hu> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | createdb problem |
Date: | 1998-11-18 15:12:08 |
Message-ID: | 3652E3C8.D35FCD5B@prolan.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I use postgres v6.4. My standard database is in /usr/local/pgsql/data
directory and the PGDATA environment variable points to this database
directory. But I'd like to create another database into another
directory. So I tried this:
killall postmaster
initdb --pgdata=/home/postgres/database --that's OK
postmaster -i -D /home/postgres/database -S -o -F
createdb -D /home/postgres/database gazmuvek --that's not good
the answer is:
ERROR: Unable to locate path '/home/postgres/database/gazmuvek'
This may be due to a missing environment variable in
the server
After this I tried to type another command:
createdb gazmuvek
It was successfull, but the database 'gazmuvek' was created into
$PGDATA. But it wasn't my desire. I need the database 'gazmuvek' in the
directory: /home/postgres/database!
What is the solution?
Thank you in advance!
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Feurer | 1998-11-19 11:19:46 | Merging databases |
Previous Message | Oliver Elphick | 1998-11-17 17:43:12 | Re: [SQL] How To Use JOIN? |