alternative DB locations

From: Bob Parkinson <rwp(at)biome(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: alternative DB locations
Date: 2000-10-03 13:50:17
Message-ID: Pine.OSF.4.21.0010031443250.23595-100000@omni.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm just trying the three lines from the initlocation online man page
(version 7.0.2) as postgres. postgres owns the locations, and initlocation
runs OK, but it don't like to create the DB.

omni.ac.uk> whoami
postgres
omni.ac.uk> export PGDATA2=/public_searchable_0
omni.ac.uk> initlocation PGDATA2
The location will be initialized with username "postgres".
This user will own all the files and must also own the server process.

Fixing permissions on pre-existing directory /public_searchable_0
Fixing permissions on pre-existing directory /public_searchable_0/base

initlocation is complete.
You can now create a database using
CREATE DATABASE <name> WITH LOCATION = 'PGDATA2'
in SQL, or
createdb <name> -D 'PGDATA2'
from the shell.

omni.ac.uk> createdb 'testdb' -D 'PGDATA2'
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 shell is bash. What am I missing please?

Cheers,

Bob

Bob Parkinson
rwp(at)biome(dot)ac(dot)uk
------------------------------------------------------------------
Technical Manager: Biome http://biome.ac.uk/

Greenfield Medical Library,
Queens Medical Centre,
Nottingham. 0115 9249924 x 42059
------------------------------------------------------------------
We are stardust

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nelson Ferreira Jr 2000-10-03 14:18:17 Re: alternative DB locations
Previous Message Nelson Ferreira Jr 2000-10-03 13:41:43 Re: trouble with trigger/function???