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
Artificial intelligence is changing the tech world at lightning speed. From automated chatbots to AI-generated applications, many people are now…
Introduction to Bot Traffic Bot traffic refers to visits to a website that come from automated software programs rather than…
Windows may look like a point-and-click operating system, but under the hood, commands still do a lot of the heavy…
YouTube Shorts are short-form vertical videos designed for quick consumption, typically lasting up to 60 seconds. In 2026, they’ve become…
YouTube SEO Secrets That Actually Work in 2026 YouTube SEO 2026 YouTube SEO Secrets That Actually Work in 2026 If…