cPanel Databases

How to Enable PostgreSQL Remote Access in cPanel

PostgreSQL Remote Access
PostgreSQL Remote Access

How to Enable PostgreSQL Remote Access in cPanel

Enable PostgreSQL Remote Access is a simple task. You need to edit two configuration files to achieve this. PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.

The first file to edit is /var/lib/pgsql/data/pg_hba.conf. Please open the file using any file editor tool.

 
vim /var/lib/pgsql/data/pg_hba.conf

Then add the following to the bottom of the file.

 
host all all 1.2.3.4/32 trust

Replace 1.2.3.4 with the remote IP. Also, please do not forget to add the CIDR value. You can also change the trust to md5 if you only want that host to be able to log in using an MD5 encrypted password (trust allows them to connect unconditionally).

Secondly, you need to edit the file /var/lib/pgsql/data/postgresql.conf

 
vim /var/lib/pgsql/data/postgresql.conf

and change the line listen_addresses= ‘localhost’ to the following.

 
listen_addresses= '*'

Also, you need to add the PostgreSQL port 5432 on your firewall to allow the connections and restart the PostgreSQL service.

 
/etc/init.d/postgresql restart

Then test the connection.

Advantages

Over-deployment is what some proprietary database vendors regard as their #1 license compliance problem.  There is no associated licensing cost for PostgreSQL.

This has several additional advantages:

  • More profitable business models with wide-scale deployment.
  • No need to audit for license compliance at any stage.
  • Flexibility to do concept research. It does not need to include additional licensing costs.

That’s it!

If you like this post and wish to receive more articles from us, please like our FB page: Grepitout

Your suggestions and feedbacks will encourage us and help to improve further, please feel free to write your comments.

For more details on our services, please drop us an E-mail at info@grepitout.com