Upgrading Postgresql on a Virtualmin server

1 post / 0 new
#1 Thu, 07/16/2015 - 18:52
Brook

Upgrading Postgresql on a Virtualmin server

Followed instructions here: http://www.liquidweb.com/kb/how-to-install-and-connect-to-postgresql-on-... however getting stuck in applying the changes to Virtualmin:

[quote] Webmin > servers > postgres > module config > system config

Path to psql command: 
    /usr/pgsql-9.3/bin/psql
Command to start PostgreSQL:
    systemctl start postgresql-9.3
Command to stop PostgreSQL:
    systemctl stop postgresql-9.3
Command to initialize PostgreSQ:
    /usr/pgsql-9.3/bin/postgresql93-setup initdb
Path to postmaster PID file:
    /var/run/postmaster-9.3.pid
Paths to host access config file:
    /var/lib/pgsql/9.3/data/pg_hba.conf
Path to pg_dump command:
    /usr/pgsql-9.3/bin/pg_dump
Path to pg_restore command:
    /usr/pgsql-9.3/bin/pg_restore
Default backup repository directory:
    /var/lib/pgsql/9.3/backups[/quote]

These are based of the settings I had on my CentOS 6 server - but there doesn't seem to be a pid on a CentOS 7 install, and virtualmin is complaining that Postgres isn't running.

Any ideas on how to set it up correctly?