On 11/9/2015 5:50 PM, John R Pierce wrote:
these instructions are specific to RHEL 6/CentOS6 and assume you've
installed postgresql from the yum.postgresql.org repository. all
commands run as root. /path/to/new/data must be owned by
postgresql:postgresql and have 700 permissions.
cd /etc/init.d
cp postgresql-9.4 postgresql-9.4B
cd /etc/sysconfig/pgsql
echo PGPORT=5433 > postgresql-9.4B
echo PGDATA=/path/to/new/data >> postgresql-9.4B
chkconfig postgresql-9.4B on
service postgresql-9.4B initdb
service postgresql-9.4B start
and wow, I forgot. this no longer works with PG 9.4, instead of
setting PGPORT in /etc/sysconfig/pgsql/$SERVICENAME, you have to edit
/path/to/new/data/postgresql.conf after the initdb step and change the
port number there before you can start the service.
I'm not sure why they did this, its quite annoying as you can't readily
see which postmaster process is on which port when you examine `ps` output.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
