From: | Wasim Devale <wasimd60(at)gmail(dot)com> |
---|---|
To: | mmikram(at)gmail(dot)com |
Cc: | leo(at)workfile(dot)de, pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Remote access on Windows Server |
Date: | 2024-07-02 07:41:44 |
Message-ID: | CAB5fag4jrL=ym9kutzHy+ObvAtah4k7X0QZPc8PiYkCqi7EO7w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>>
>>
>>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Jakobs | 2024-07-02 08:39:37 | Re: Remote access on Windows Server |
Previous Message | Muhammad Ikram | 2024-07-02 07:40:21 | Re: Remote access on Windows Server |