- Plesk Onyx 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 possible different path to the files.
To enable remote access to PostgreSQL server:
Connect to the PostgreSQL server via SSH.
Get location of
postgresql.conffile by executing 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 all all 203.0.113.2/32md5
- 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.
As for other authentication methods refer to PostgreSQL documentation .
Restart PostgreSQL server to apply the changes:
# service postgresql restart