Re: Remote access on Windows Server

[Muhammad Ikram <mmikram@xxxxxxxxx>]

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@xxxxxxxxxxx> 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