From: | Holger Schurig <h(dot)schurig(at)mn-logistik(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | initlocation / createdb won't work |
Date: | 2001-01-23 09:42:28 |
Message-ID: | 01012310422800.01973@mnz66.mn-logistik.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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 ...
From | Date | Subject | |
---|---|---|---|
Next Message | tfo | 2001-01-23 20:42:58 | inability to restore infinity values via psql or pg_restore |
Previous Message | Bruce Momjian | 2001-01-23 03:49:16 | Re: select cash_out('2'); crashes backend on 7.0.2 |