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