Received: from aix.prolan.hu (aix.prolan.hu [193.91.83.253]) by hub.org (8.9.1/8.9.1) with ESMTP id JAA08347 for ; Wed, 18 Nov 1998 09:10:22 -0500 (EST) (envelope-from gyurika@prolan.hu) Received: from prolan.hu (lendvary-g.prolan.hu [193.91.83.34]) by aix.prolan.hu (8.9.1a/8.9.1) with ESMTP id PAA23476 for ; Wed, 18 Nov 1998 15:13:30 +0100 Sender: gyurika@aix.prolan.hu Message-ID: <3652E3C8.D35FCD5B@prolan.hu> Date: Wed, 18 Nov 1998 15:12:08 +0000 From: Lendvary Gyorgy Organization: Prolan Co. X-Mailer: Mozilla 4.05 [en] (X11; I; Linux 2.0.30 i586) MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: createdb problem Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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!