Re: Customising pg directories - Mailing list pgsql-general

From Raghavendra
Subject Re: Customising pg directories
Date
Msg-id CA+h6AhjOieYOGQ-wezJJ52uTcFs=hsuD_1VmNwHwDg3RDxzEug@mail.gmail.com
Whole thread Raw
In response to Customising pg directories  (Ben Carbery <ben.carbery@gmail.com>)
List pgsql-general
Thanks too... :)

--Raghav

On Thu, Jun 28, 2012 at 4:52 PM, Ben Carbery <ben.carbery@gmail.com> wrote:
Too easy, thanks.

On 28 June 2012 18:38, Raghavendra <raghavendra.rao@enterprisedb.com> wrote:
> On Thu, Jun 28, 2012 at 1:20 PM, Ben Carbery <ben.carbery@gmail.com> wrote:
>>
>> I am building a new server with a separate partition for data and
>> xlogs. What is the correct way to do this?
>>
>> Can I create a symlink from /var/lib/pgsql/9.1/data -> /pg_data (and
>> then a symlink in /pgdata for xlogs-> /pg_xlog)
>> Or do I have to modify $PGDATA in the init script?
>>
>> This is all after installing packages but prior to 'service
>> postgresql-91 initdb'
>>
>> cheers
>>
>
> initdb --pgdata <datadirectory> --xlogdir <pg_xlog location>, is the command
> which suit's your requirement.
>
> This command will take care of creating symblinks as well.
>
> ---
> Regards,
> Raghavendra
> EnterpriseDB Corporation
> Blog: http://raghavt.blogspot.com/
>

pgsql-general by date:

Previous
From: Arjen Nienhuis
Date:
Subject: Re: create a script which imports csv data
Next
From: Tom Lane
Date:
Subject: Re: create database from template requires the source database to be unused