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

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: mlw <markw(at)mohawksoft(dot)com>
Cc: Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: create database name with location = 'path';
Date: 2001-05-08 15:28:13
Message-ID: 3AF8108D.F159EC13@tm.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)org

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Klimov 2001-05-08 15:29:38 Is `#!/bin/sh' configurable?
Previous Message Alexander Klimov 2001-05-08 15:22:09 Re: Where `gcc -MMD' puts .d files