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 ?
Show quoted text
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