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