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
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…
Managing access correctly is one of the most important aspects of running a secure and scalable WordPress website. Managing access…
Customer reviews have become one of the most influential factors in modern buying decisions. Before choosing a product, service, or…
