On 11/11/2010 08:15 PM, Guillaume Lelarge wrote:
>>
>> I would like to create a specific database on a another location (not in
>> "data_directory = '/var/lib/postgresql/8.3/main'" ). I was wondering if
>> I have to run
>> initdb -D /other/path/
>>
>> of if there is another way
>>
>
> To create another database in another location, you first need to create
> a tablespace, and then create a database in that tablespace. For
> example, in psql:
>
> CREATE TABLESPACE otherlocation LOCATION '/some/specific/directory';
> CREATE DATABASE newdb TABLESPACE otherlocation;

Hey thanks again, that did the job :)

In response to

• Re: ignore errors for COPY [solved] at 2010-11-11 18:15:28 from Guillaume Lelarge

pgsql-general by date

Next:	From: Михаил Филоненко	Date: 2010-11-12 10:04:14
	Subject: Re: NOTIFY/LISTEN why is not a callback as notice processing.
Previous:	From: Dmitriy Igrishin	Date: 2010-11-12 09:50:14
	Subject: Re: More then 1600 columns?