initlocation / createdb won't work
Holger Schurig <h.schurig@mn-logistik.de>
From: Holger Schurig <h.schurig@mn-logistik.de>
To: pgsql-bugs@postgresql.org
Date: 2001-01-23T09:42:28Z
Lists: pgsql-bugs
I have the postgresql-7.0.3-2 rpm from ftp.postgresql.org installed on a Red Hat 6.2 box. However, I get a strange error. Running as user "postgres" I execute the following statements: CREATE DATABASE mnz66:~$ initlocation /var/tmp/xx The location will be initialized with username "postgres". This user will own all the files and must also own the server process. Creating directory /var/tmp/xx Creating directory /var/tmp/xx/base initlocation is complete. mnz66:~$ createdb testdb -D '/var/tmp/xx/testdb' ERROR: The database path '/var/tmp/xx/testdb' is invalid. This may be due to a character that is not allowed or because the chosen path isn't permitted for databases createdb: database creation failed So it seems that I have to play symlink tricks to get my database anywhere else then in /var/lib/pqsql/data ...