From: | Aaron Brown <aaron(at)results-computing(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | createdb failing |
Date: | 2001-04-26 00:20:18 |
Message-ID: | 988244418.3ae769c24e21a@webmail.results-computing.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I am trying to create a new database in an alternate location using
'initlocation' and 'createdb'.
The 'initlocation' utility appears to work, but 'createdb' always fails with the
following error:
"ERROR: The database path 'PGDATA2' 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"
The path I am using is '/postgres/SERVICES', which does not appear to have
invalid characters.
I put the absolute path of the new location in the PGDATA2 environment variable,
which is visible to the postmaster because the variable is set at system startup
in /etc/profile.local.
I have tried 'initlocation' and 'createdb' using absolute paths (no environment
variable) and I always get the same error. I have even tried "CREATE DATABASE
WITH LOCATION" directly inside of psql.
I noticed that 'initlocation' created the new directory and a 'base'
subdirectory. The 'base' directory is empty. Should the 'base' directory be
empty?
I am running PostgreSQL 7.0.2 on a SuSE 7.0 x86 box.
Any help is greatly appreciated. Thank you.
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2001-04-26 01:03:39 | Re: logs |
Previous Message | Joel Burton | 2001-04-25 21:46:27 | Re: logs |