Re: create database name with location = 'path'; - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: create database name with location = 'path';
Date
Msg-id 3AF8108D.F159EC13@tm.ee
Whole thread Raw
In response to create database name with location = 'path';  (mlw <markw@mohawksoft.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Changes needed to build on NetBSD
Next
From: Alexander Klimov
Date:
Subject: Is `#!/bin/sh' configurable?