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.