Postgres Pro
Downloads
Home   >   mailing lists

Re: Remote access on Windows Server - Mailing list pgsql-admin

From Muhammad Ikram
Subject Re: Remote access on Windows Server
Date
Msg-id CAGeimVoupf=JVJgGhxx5YVK75nPgJem4oy=RUk-b3FBzvDf+vg@mail.gmail.com
Whole thread Raw
In response to Remote access on Windows Server  ("Rainer Leo" <leo@workfile.de>)
Responses Re: Remote access on Windows Server
List pgsql-admin
Tree view
Hi,

0.0.0/0 trust will make access . This will compromise security.
For rest think of firewall rules


Muhammad Ikram,
Butnine global.



On Tue, 2 Jul 2024 at 11:46, Rainer Leo <leo@workfile.de> wrote:
Hello, we use postgres 13.15 and have to use Windows Datacenter 2022

I cannot figure out how to configure postgres for secure remote access.
It is not possible to use IP whitelisting or VPN, because the user do not provide anything
beside host/name/port/user/password

# this works but it grants access without password
host    all      all      0.0.0.0/0      trust


# these two are unable to establish connection
host    all      all      0.0.0.0/0      md5
host    all      all      0.0.0.0/0      scram-sha-256


listen_addresses = '*' in postgresql.conf is set


What is the secure way to ensure remote access on Windows Server?

Thanks for any help!

Regards, Leo



pgsql-admin by date:

Previous
From: "Rainer Leo"
Date:
Subject: Remote access on Windows Server
Next
From: Wasim Devale
Date:
Subject: Re: Remote access on Windows Server