pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Database Locations 3+ messages / 3 participants [nested] [flat]
* Database Locations @ 2002-04-02 08:16 Keith Gray <keith@heart.com.au> 0 siblings, 1 reply; 3+ messages in thread From: Keith Gray @ 2002-04-02 08:16 UTC (permalink / raw) To: pgsql-sql 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Database Locations @ 2002-04-02 17:08 Peter Eisentraut <peter_e@gmx.net> parent: Keith Gray <keith@heart.com.au> 0 siblings, 1 reply; 3+ messages in thread From: Peter Eisentraut @ 2002-04-02 17:08 UTC (permalink / raw) To: Keith Gray <keith@heart.com.au>; +Cc: pgsql-sql Keith Gray writes: > Has anyone had any joy with this example taken from documentation. > olly=> create database test1 with location='/home/olly/private_db'; > ERROR: Absolute paths are not allowed as database locations Please read this (to the very end): http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/managing-databases.html#MANAGE-AG-ALTERN... -- Peter Eisentraut peter_e@gmx.net ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Database Locations @ 2002-04-02 17:29 Tom Lane <tgl@sss.pgh.pa.us> parent: Peter Eisentraut <peter_e@gmx.net> 0 siblings, 0 replies; 3+ messages in thread From: Tom Lane @ 2002-04-02 17:29 UTC (permalink / raw) To: Peter Eisentraut <peter_e@gmx.net>; +Cc: Keith Gray <keith@heart.com.au>; pgsql-sql Peter Eisentraut <peter_e@gmx.net> writes: > Keith Gray writes: >> Has anyone had any joy with this example taken from documentation. > Please read this (to the very end): > http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/managing-databases.html#MANAGE-AG-ALTERN... But it does seem an unfortunate choice of example for the CREATE DATABASE reference page to illustrate using a feature that's disabled by default. Seems like the ref page should mention that you need to have compiled with whatever-that-option-symbol-is; or perhaps better, improve the example to show how to do it with an environment variable. regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-04-02 17:29 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2002-04-02 08:16 Database Locations Keith Gray <keith@heart.com.au> 2002-04-02 17:08 ` Peter Eisentraut <peter_e@gmx.net> 2002-04-02 17:29 ` Tom Lane <tgl@sss.pgh.pa.us>
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