How to enable remote access to PostgreSQL databases hosted in Plesk

Comments

1 comment

  • Avatar
    Yunus @ dlabsit.nl (Edited )

    Hello

    To make the remote access work from the Plesk Panel this is my setup

    Step 1: edit postgresql.conf change the line to:

    listen_addresses = '*'

    Step 2: add the following lines in pg_hba.conf:

    # Allow all IPv4 addresses with SCRAM-SHA-256
    host    all    all    0.0.0.0/0    scram-sha-256
    
    # Allow all IPv6 addresses with SCRAM-SHA-256
    host    all    all    ::/0         scram-sha-256
    

    Step 3: In the Plesk Admin panel. Change the firewall service for PostgreSQL server to DENY.

    Now when you make a user there you can specify for each database the remote access. Every change needs to be applied in the Firewall page.

    0

Please sign in to leave a comment.

Have more questions? Submit a request