Thread: create database name with location = 'path';

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?

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

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