How do I allow remote computer to connect to PostgreSQL – ORO POS – Point of Sale

How do I allow remote computer to connect to PostgreSQL

PostgreSQL database server by default does not allow the remote computers to connect to that. This is restricted for security reasons. To allow remote connections to PostgreSQL database server from other locations you need to change the followings


You can go to the computer or, in case that’s in a Linux server ssh to login to that

dbuser@oropc:~$ ssh root@remote-host

By default, PostgreSQL DB server listen-address is set to the ‘localhost’ , and we need to change it so it accepts connection from any IP address; or you can use comma-separated list of addresses.  

Open your postgresql.conf  file in your editor. We prefer to use notepad++ in Window. In Linux you can use vim or nano. 

Disclaimer: The information and media included on this website are not legal documents. Whilst we make every attempt to ensure the accuracy and reliability of the information contained in the documents stored, served and accessed on this site, this information should not be relied upon as a substitute for formal advice from our company. Features described in this document are subject to change without any notice.