pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / 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>
  2002-04-02 17:08 ` Re: Database Locations Peter Eisentraut <peter_e@gmx.net>
  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 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   ` Re: Database Locations Tom Lane <tgl@sss.pgh.pa.us>
  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 08:16 Database Locations Keith Gray <keith@heart.com.au>
  2002-04-02 17:08 ` Re: Database Locations Peter Eisentraut <peter_e@gmx.net>
@ 2002-04-02 17:29   ` Tom Lane <tgl@sss.pgh.pa.us>
  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