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
Black Friday 2025 is here — the biggest shopping moment of the year, where customers expect unbeatable prices, fast performance,…
When you move or delete a page on your WordPress website, visitors — and search engines — can easily hit…
Introduction Artificial Intelligence has made remarkable strides — from writing poetry to generating code. Yet, most AIs still act like…
Introduction Artificial Intelligence has revolutionized the way we create, refine, and scale written content — from blogs and marketing campaigns…
Every Diwali Brings New Light, New Beginnings, and New Opportunities In today’s digital world, your website is the Diya that…
