Set up PostgreSQL on a Debian or Ubuntu in Vesta Control Panel, How to set up PostgreSQL on a Debian or Ubuntu in Vesta Control Panel, Hostripples Web Hosting

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, How to set up PostgreSQL on a Debian or Ubuntu in Vesta Control Panel, Hostripples Web Hosting

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


How to set up PostgreSQL on a Debian or Ubuntu in Vesta Control Panel, Hostripples Web Hosting
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.