- Plesk for Linux
How to enable remote access to PostgreSQL server on a Plesk server?
Note: the instructions below were tested on a Plesk server, however, they can be applicable to a non-Plesk server as well keeping in mind the possible different paths to the files.
To enable remote access to PostgreSQL server:
Connect to the PostgreSQL server via SSH.
Get location of
postgresql.conffile by executing the command (it should be something like
CONFIG_TEXT: # find / -name "postgresql.conf"
postgresql.conffile and add the following line to the end:
CONFIG_TEXT: listen_addresses = '*'
Add the following line to the end of
CONFIG_TEXT: host samerole all 203.0.113.2/32 md5
- 203.0.113.2/32 is the remote IP from which connection is allowed. If you want to allow connection from any IP specify 0.0.0.0/0 .
- md5 is the authentication method, which requires the client to supply a double-MD5-hashed password for authentication.
Warning: In the above configuration user john.doe from database example1 has access to database example1 only. To allow user john.doe remotely connect to example1 database as well as other databases like example2 database and vice versa, specify directives as following at the end of
host all all 203.0.113.2/32 md5
As for other authentication methods refer to PostgreSQL documentation.
Restart PostgreSQL server to apply the changes:
# service postgresql restart
Note: if PostgreSQL port was not customized then port 5432 can be configured on the firewall in order to allow access to specific IPs using the following article.