Allowing client access

Поиск
Список
Период
Сортировка
От Timmy Siu
Тема Allowing client access
Дата
Msg-id d08c493f-9845-2ab6-c0e3-6e0044eec452@aol.com
обсуждение исходный текст
Ответы Re: Allowing client access
Список pgsql-general
Дерево обсуждения

Dear All Users,

  • How do I allow an external client IP address access to my pgsql server?
According to my own experience and test, if I set the external client IP address to, for example, 111.222.333.444 in the file /etc/postgresql/11/main/pg_hba.conf, it will not be able to connect to the server:
#TYPE?????? DATABASE?????? ?? USER?????? ?????? ?????? ADDRESS?????? ?????? ?????? METHOD
host?????? all?????? ?????? ?????? testuser ???? ?????? 111.222.333.444?????? md5

I must set "address" to "any" as in the following:
#TYPE?????? DATABASE?????? ?? USER?????? ?????? ?????? ADDRESS?????? ?????? METHOD
host?????? all?????? ?????? ?????? testuser ???? ?????? 0.0.0.0/0?????? ?? md5


  • Can I limit access to my pgsql server through TCP Wrapper? What is the related executable?


Regards,
Timmy

??

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