From: | Vangelis Katsikaros <ibob17(at)yahoo(dot)gr> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ignore errors for COPY [solved] |
Date: | 2010-11-12 10:03:35 |
Message-ID: | 4CDD10F7.60701@yahoo.gr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 :)
From | Date | Subject | |
---|---|---|---|
Next Message | Михаил Филоненко | 2010-11-12 10:04:14 | Re: NOTIFY/LISTEN why is not a callback as notice processing. |
Previous Message | Dmitriy Igrishin | 2010-11-12 09:50:14 | Re: More then 1600 columns? |