On Thu, Jun 28, 2012 at 1:20 PM, Ben Carbery <ben.carbery@xxxxxxxxx> 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.