How to set up PostgreSQL on a Debian or Ubuntu in Vesta Control Panel

Set up PostgreSQL on a Debian or Ubuntu in Vesta Control Panel

Step 1. Install PostgreSQL packages

apt-get install postgresql postgresql-contrib phppgadmin

Step 2. Download hba configuration

wget http://c.vestacp.com/0.9.8/debian/pg_hba.conf -O /etc/postgresql/*/main/pg_hba.conf

Step 3. Restart the server

service postgresql restart

Step 4. Set oracle user password

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

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

Step 6. Register pg instance in control panel

v-add-database-host pgsql localhost postgres pgp4sw0rd

Step 7. Download phpPgAdmin configuration

wget http://c.vestacp.com/0.9.8/debian/pga.conf -O /etc/phppgadmin/config.inc.php
wget http://c.vestacp.com/0.9.8/debian/apache2-pga.conf -O /etc/apache2/conf.d/phppgadmin

Step 8. Restart web server

service apache2 restart

Vishwajit Kale

Vishwajit Kale blazed onto the digital marketing scene back in 2015 and is the digital marketing strategist of Hostripples, a company that aims to provide affordable web hosting solutions. Vishwajit is experienced in digital and content marketing along with SEO. He's fond of writing technology blogs, traveling and reading.

View all posts