From: | Muhammad Ikram <mmikram(at)gmail(dot)com> |
---|---|
To: | Rainer Leo <leo(at)workfile(dot)de> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Remote access on Windows Server |
Date: | 2024-07-02 07:40:21 |
Message-ID: | CAGeimVoupf=JVJgGhxx5YVK75nPgJem4oy=RUk-b3FBzvDf+vg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 | Wasim Devale | 2024-07-02 07:41:44 | Re: Remote access on Windows Server |
Previous Message | Rainer Leo | 2024-07-02 06:46:24 | Remote access on Windows Server |