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
