Allowing client access

Поиск
Список
Период
Сортировка
Искать
От
Timmy Siu
Тема
Allowing client access
Дата
Msg-id
d08c493f-9845-2ab6-c0e3-6e0044eec452@aol.com
Список
Дерево обсуждения
Allowing client access Timmy Siu <timmy.siu@aol.com>
Re: Allowing client access Bob Jolliffe <bobjolliffe@gmail.com>
Re: Allowing client access Timmy Siu <timmy.siu@aol.com>
Re: Allowing client access Adrian Klaver <adrian.klaver@aklaver.com>

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 по дате отправления
Предыдущее
От: Luca Ferrari
Дата:
Следующее
От: Bob Jolliffe
Дата:
Сообщение: Re: Allowing client access
FAQ