Skip site navigation (1) Skip section navigation (2)

createdb failing

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: (view raw, whole thread or download thread mbox)
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

I am running PostgreSQL 7.0.2 on a SuSE 7.0 x86 box.

Any help is greatly appreciated.  Thank you.


pgsql-admin by date

Next:From: Lamar OwenDate: 2001-04-26 01:03:39
Subject: Re: logs
Previous:From: Joel BurtonDate: 2001-04-25 21:46:27
Subject: Re: logs

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group