From: | Timmy Siu <timmy(dot)siu(at)aol(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Allowing client access |
Date: | 2019-10-09 12:33:41 |
Message-ID: | d08c493f-9845-2ab6-c0e3-6e0044eec452@aol.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Jolliffe | 2019-10-09 12:40:50 | Re: Allowing client access |
Previous Message | Euler Taveira | 2019-10-09 12:07:40 | Re: v12 and pg_restore -f- |