PostgreSQL 8.4 is the latest version installed via cPanel, and supported. That said, 9.x can be installed manually:
Use the correct package for your distro ( NOTE: Example instructions shown spec 9.2, all versions available here:http://yum.postgresql.org/repopackages.php )
#rpm -i http://yum.postgresql.org/9.2/redhat/rhel-6-i386/pgdg-centos92-9.2-6.noarch.rpm
Install the server
# yum groupinstall “PostgreSQL Database Server PGDG”
Setup the server
# service postgresql-9.2 initdb
# chkconfig postgresql-9.2 on
Install the symlinks necessary
# cd /usr/pgsql-9.2/bin/; for f in *; do echo $f; [ -e /usr/bin/$f ] && mv /usr/bin/$f /usr/bin/$f.8; ln -s $(pwd)/$f /usr/bin/$f; done
# cd /var/lib/pgsql; ln -s 9.2/backups; ln -s 9.2/data; ln -s 9.2/pgstartup.log
Then in WHM ‘configure postres’ – in “Home »SQL Services »Configure Postgres”
— click on install config
— you can also “create users” for previously created cPanel accounts
You can also phppgadmin by running:
# /usr/local/cpanel/bin/updatephppgadmin –force
The pg_upgrade utility is available to upgrade the data files from 8.4.7, to 9.3. Review its documentation here:
http://www.postgresql.org/docs/9.3/static/pgupgrade.html
I would not recommend this upgrade unless you are very familiar with PostgreSQL.