How to set up PostgreSQL on a RHEL or CentOS in Vesta Control Panel

Set up PostgreSQL on a RHEL or CentOS in Vesta Control Panel

1. Install PostgreSQL packages

yum install postgresql postgresql-server postgresql-contrib phpPgAdmin

* If you have remi installed then don’t forget to explicitly enable it.

yum install –enablerepo=remi postgresql postgresql-server postgresql-contrib phpPgAdmin

2. Initialize database cluster

service postgresql initdb

3. Download hba configuration

wget http://c.vestacp.com/0.9.8/rhel/pg_hba.conf -O /var/lib/pgsql/data/pg_hba.conf

4. Start the server

service postgresql start

5. Set oracle user password

su – postgres
psql -c “ALTER USER postgres WITH PASSWORD ‘pgp4sw0rd'”
exit

6. Enable pgsql databases support in vesta.
open /usr/local/vesta/conf/vesta.conf and set DB_SYSTEM to ‘mysql,pgsql’

7. Register pg instance in control panel

v-add-database-host pgsql localhost postgres pgp4sw0rd

8. Download phpPgAdmin configuration

wget http://c.vestacp.com/0.9.8/rhel/pga.conf -O /etc/phpPgAdmin/config.inc.php
wget http://c.vestacp.com/0.9.8/rhel/httpd-pga.conf -O /etc/httpd/conf.d/phpPgAdmin.conf

9. Restart web server

service httpd restart