Re: Remote access on Windows Server

Поиск
Список
Период
Сортировка
От Muhammad Ikram
Тема Re: Remote access on Windows Server
Дата
Msg-id CAGeimVoupf=JVJgGhxx5YVK75nPgJem4oy=RUk-b3FBzvDf+vg@mail.gmail.com
обсуждение исходный текст
Ответ на Remote access on Windows Server  ("Rainer Leo" <leo@workfile.de>)
Ответы Re: Remote access on Windows Server
Список 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@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



В списке pgsql-admin по дате отправления: