I have ALLOW_ABSOLUTE_DBPATHS enabled. but it does not do what one would
assume.

template1=# create database fubar with location = '/tmp'  ;
ERROR:  CREATE DATABASE: could not link '/postgres/data/base/12523613' to
'/tmp/base/12523613': Operation not permitted

Is this telling me it is creating the database as it always does, but is
linking it to the specified location ?

If so, what's the point of this?

Mon, 07 May 2001 19:44:00 -0400
mlw <markw@mohawksoft.com>
create database name with location = 'path';
mlw <markw@mohawksoft.com> writes:
> template1=# create database fubar with location = '/tmp'  ;
> ERROR:  CREATE DATABASE: could not link '/postgres/data/base/12523613' to
> '/tmp/base/12523613': Operation not permitted

Try using a filesystem that supports symbolic links ...

			regards, tom lane

Mon, 07 May 2001 21:42:04 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: create database name with location = 'path'; 
mlw wrote:

> I have ALLOW_ABSOLUTE_DBPATHS enabled. but it does not do what one would
> assume.
>
> template1=# create database fubar with location = '/tmp'  ;
> ERROR:  CREATE DATABASE: could not link '/postgres/data/base/12523613' to
> '/tmp/base/12523613': Operation not permitted
>

Do you have /tmp/base directory ?

> Is this telling me it is creating the database as it always does, but is
> linking it to the specified location ?
>
> If so, what's the point of this?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


Tue, 08 May 2001 17:28:13 +0200
Hannu Krosing <hannu@tm.ee>
Re: create database name with location = 'path';