Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: create database name with location = 'path';
Date
Msg-id 26310.989286124@sss.pgh.pa.us
Whole thread Raw
In response to create database name with location = 'path';  (mlw <markw@mohawksoft.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Barry Lind
Date:
Subject: Re: MULTIBYTE and SQL_ASCII (was Re: [JDBC] Re: A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars?)
Next
From: Ian Lance Taylor
Date:
Subject: Re: CVS branch management (was Re: A problem with new pg_dump)