Received: from gateway.heart.com.au (unknown [203.12.235.237]) by postgresql.org (Postfix) with ESMTP id A98FF475A1A for ; Tue, 2 Apr 2002 03:15:29 -0500 (EST) Received: from tardis.heart.com.au (IDENT:root@tardis.heart.com.au [192.168.0.42]) by gateway.heart.com.au (8.11.2/8.11.2) with ESMTP id g32Icjs17025 for ; Wed, 3 Apr 2002 04:38:45 +1000 Received: from heart.com.au ([192.168.0.53]) by tardis.heart.com.au (8.9.3/8.8.7) with ESMTP id SAA13997 for ; Tue, 2 Apr 2002 18:15:07 +1000 Message-ID: <3CA968C5.57B8CD9E@heart.com.au> Date: Tue, 02 Apr 2002 18:16:05 +1000 From: Keith Gray X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: SQL Subject: Database Locations Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200204/12 X-Sequence-Number: 7277 Has anyone had any joy with this example taken from documentation. $ mkdir private_db $ initlocation ~/private_db Creating Postgres database system directory /home/olly/private_db/base $ psql olly Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL 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 test1 ERROR: Absolute paths are not allowed as database locations createdb: database creation failed -- Keith Gray Technical Development Manager Heart Consulting Services P/L mailto:keith@heart.com.au