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
YouTube SEO Secrets That Actually Work in 2026 YouTube SEO 2026 YouTube SEO Secrets That Actually Work in 2026 If…
Live video commerce is transforming how small businesses sell products online. Instead of relying only on static product pages or…
Digital marketing directly impacts revenue, brand positioning, and customer acquisition cost. Choosing the wrong agency can result in wasted budgets,…
The release of WordPress 6.9 introduces meaningful enhancements focused on performance, block editing flexibility, design precision, and long-term scalability. This…
The wp-content/uploads folder is the core storage location for media files in WordPress. Every image, PDF, video, or document uploaded…
