> 
> 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?

    man initlocation


Jan


-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #


Tue, 24 Nov 1998 10:54:15 +0100 (MET)
jwieck@debis.com (Jan Wieck)
Re: [HACKERS] createdb problem
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?




Tue, 24 Nov 1998 10:13:58 +0000
Lendvary Gyorgy <gyurika@prolan.hu>
createdb problem