Applicable to:
- Plesk Onyx for Linux
Question
How to enable remote access to PostgreSQL server on a Plesk server?
Answer
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/var/lib/pgsql/data/postgresql.conf):CONFIG_TEXT: # find / -name "postgresql.conf"
-
Open
postgresql.conffile and add the following line to the end:CONFIG_TEXT: listen_addresses = '*'
-
Add the following line to the end of
/var/lib/pgsql/data/pg_hba.conffile: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
Comments
2 comments
It's crazy to suggest `trust` as authentication method for a remote connection, please take down this guide ASAP.
Hello @Michael Banck,
Thank you for your feedback!
The article was updated to include "md5" authentification method to avoid any security issues.
Please sign in to leave a comment.