Re: Customising pg directories

From: Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>
To: Ben Carbery <ben(dot)carbery(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Customising pg directories
Date: 2012-06-28 16:06:46
Message-ID: CA+h6AhjOieYOGQ-wezJJ52uTcFs=hsuD_1VmNwHwDg3RDxzEug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks too... :)

--Raghav

On Thu, Jun 28, 2012 at 4:52 PM, Ben Carbery <ben(dot)carbery(at)gmail(dot)com> wrote:

> Too easy, thanks.
>
> On 28 June 2012 18:38, Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>
> wrote:
> > On Thu, Jun 28, 2012 at 1:20 PM, Ben Carbery <ben(dot)carbery(at)gmail(dot)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/
> >
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-06-28 16:22:35 Re: create database from template requires the source database to be unused
Previous Message Arjen Nienhuis 2012-06-28 16:01:39 Re: create a script which imports csv data