Database Locations

Has anyone had any joy with this example taken from documentation.

$ mkdir private_db$ initlocation ~/private_dbCreating Postgres database system directory /home/olly/private_db/base  $
psqlollyWelcome to psql, the PostgreSQL interactive terminal.Type:  \copyright for distribution terms       \h for help
withSQL commands       \? for help on internal slash commands       \g or terminate with semicolon to execute query
 \q to quit
 
olly=> CREATE DATABASE elsewhere WITH LOCATION = '/home/olly/private_db';CREATE DATABASE



I get an error like:-
olly=> create database test1 with location='/home/olly/private_db';ERROR:  Absolute paths are not allowed as database
locations

...or at the command line...
$ createdb --location=/home/olly/private_db test1ERROR:  Absolute paths are not allowed as database locationscreatedb:
databasecreation failed
 


-- 
Keith Gray

Technical Development Manager
Heart Consulting Services P/L
mailto:keith@heart.com.au