| 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: | Whole Thread | Raw Message | 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- |