I'm to being crazy... heheh

Hi,

I'm a new user of PostgreSQL 7.2, and have basics problems...

I'm want to create a new db in a specific location. (I'm using Postgre under
WinXP)

I tried in prompt of Postgre:

[/] $ mkdir c:\dbteste
[/] $ cd c:\dbteste
[/cygdrive/c/dbteste] $ mkdir mydb
[/cygdrive/c/dbteste] $ export PGDATA=/cygdrive/c/dbteste/mydb
[/cygdrive/c/dbteste] $ initdb $PGDATA
[/cygdrive/c/dbteste] $ initlocation $PGDATA
(...)
initlocation is complete
[/cygdrive/c/dbteste] $ pg_ctl start -D PGDATA
postmaster successfully started
[/cygdrive/c/dbteste] $ createdb kern -D PGDATA
error: create database: could not initialize database directory
[/cygdrive/c/dbteste] $ createdb kern -D $PGDATA
error: Absolute paths are not allowed as database locations
[/cygdrive/c/dbteste] $ createdb kern
ok  ---  but the db is created in c:\arquiv~1\postgresql\7.2\data\base
(default directory)

and... ??????  what's the problem ?


Sandro A. Nascimento
Paulinia/SP/Brasil
God has anything for you.