Upgrading Postgresql on a Virtualmin server

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

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?