These forums are locked and archived, but all topics have been migrated to the new forum. You can search for this topic on the new forum: Search for Upgrading Postgresql on a Virtualmin server on the new forum.
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?