Re: Remote access on Windows Server

# 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

What is written to the log when access is attempted?

Am 2. Juli 2024 09:41:44 MESZ schrieb Wasim Devale <wasimd60(at)gmail(dot)com>:
>Installation of certificates made from Java will work and make SSL = on
>
>On Tue, 2 Jul, 2024, 1:10 pm Muhammad Ikram, <mmikram(at)gmail(dot)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(at)workfile(dot)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
>>>
>>>
>>>
>>>