Set up PostgreSQL on a RHEL or CentOS in Vesta Control Panel
1. Install PostgreSQL packages
yum install postgresql postgresql-server postgresql-contrib phpPgAdmin
* If you have remi installed then don’t forget to explicitly enable it.
yum install –enablerepo=remi postgresql postgresql-server postgresql-contrib phpPgAdmin
2. Initialize database cluster
service postgresql initdb
3. Download hba configuration
wget http://c.vestacp.com/0.9.8/rhel/pg_hba.conf -O /var/lib/pgsql/data/pg_hba.conf
4. Start the server
service postgresql start
5. Set oracle user password
su – postgres
psql -c “ALTER USER postgres WITH PASSWORD ‘pgp4sw0rd'”
exit
6. Enable pgsql databases support in vesta.
open /usr/local/vesta/conf/vesta.conf and set DB_SYSTEM to ‘mysql,pgsql’
7. Register pg instance in control panel
v-add-database-host pgsql localhost postgres pgp4sw0rd
8. Download phpPgAdmin configuration
wget http://c.vestacp.com/0.9.8/rhel/pga.conf -O /etc/phpPgAdmin/config.inc.php
wget http://c.vestacp.com/0.9.8/rhel/httpd-pga.conf -O /etc/httpd/conf.d/phpPgAdmin.conf
9. Restart web server
service httpd restart
Introduction to Cloud Hosting In today's digital world, website performance can make or break an online business. Whether you run…
In the world of digital marketing, getting attention is only half the battle. The real goal is to convince people…
Introduction In today's digital world, understanding website bandwidth is essential for anyone running a website. Whether you own a blog,…
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…