Database Locations - Mailing list pgsql-sql

From Keith Gray
Subject Database Locations
Date
Msg-id 3CA968C5.57B8CD9E@heart.com.au
Whole thread Raw
Responses Re: Database Locations
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "jack"
Date:
Subject: Re: About temporary table
Next
From: Masaru Sugawara
Date:
Subject: Re: optimyzing