| 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: | Whole Thread | Raw Message | 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 |