createdb problem

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!

Browse pgsql-sql by date

  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?