17 07 2013
Install PostgreSQL 9.x on cPanel.
How to install a later version of PostgreSQL than the version it provides.
Install the latest version of PostgreSQL from here.
cd /usr/src |
rpm -Uvh pgdg-centos92-9.2-6.noarch.rpm |
You can now install from yum.
yum install postgresql92 postgresql92-server postgresql92-devel |
Create some symlinks
ln -s /var/lib/pgsql/9.2/data /var/lib/pgsql |
ln -s /var/lib/pgsql/9.2/backups /var/lib/pgsql |
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 |
Initialize PostgreSQL and start it.
service postgresql-9.2 initdb |
service postgresql-9.2 start |
Login to WHM and go to:
‘SQL Services > Configure Postgres > Install Config’
Then you need to edit the pg_hba.conf
nano /var/lib/pgsql/9.2/data/pg_hba.conf |
Replace md5 with trust
Then in WHM go to;
‘Restart Services > SQL Server (PgSQL) > Yes’
‘SQL Services > Configure Postgres > Generate Password > Change Password’
‘SQL Services > Configure Postgres > Create Users’
‘Restart Services > SQL Server (PgSQL) > Yes’
Create another symlink for the config file used by pecl etc
ln -s /usr/pgsql-9.2/bin/pg_config /usr/bin |
Finished!
Xen/fstab config for a Stacklet Image. Creating users with Puppet.