Thread: Remote access on Windows Server

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

Installation of certificates made from Java will work and make SSL = on

On Tue, 2 Jul, 2024, 1:10 pm Muhammad Ikram, <mmikram@gmail.com> wrote:

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