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 :)
