From: Keith Gray <keith@heart.com.au>
To: SQL <pgsql-sql@postgresql.org>
Subject: Database Locations
Date: Tue, 02 Apr 2002 18:16:05 +1000
Message-ID: <3CA968C5.57B8CD9E@heart.com.au> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: keith@heart.com.au
Subject: Re: Database Locations
In-Reply-To: <3CA968C5.57B8CD9E@heart.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox