On Thu, 23 Dec 2021 at 15:45, shing dong wrote:
> I have tested this feature , only had
>>
>
> host VJ VJ_USER 10.10.10.1/32 md5
>
> in the pg_hba.conf file
>
I may be a bit off , but can you try a couple of things, other than a fresh
install, incase you have time to debug more.
is it
> Have checked select * from pg_hba_file_rules results are consistent with
pg_hba.conf
> any ip and user still can login in db
Any proxy? port/ip - forwarding running in the background?
in the next time check the "client_addr".
- SELECT usename, client_addr FROM pg_stat_activity where client_ad
>
> Your original post stated that you only had
> host VJ VJ_USER 10.10.10.1/32 md5
> in the pg_hba.conf file.
> However the result of the select is considerably more ?
DEAR
I have tested this feature , only had
host VJ VJ_USER 10.10.10.1/32 md5
in the pg_hba.conf file
Have ch
On Tue, 21 Dec 2021 at 22:57, shing dong wrote:
> *Dear Dave *
>
> The result after reload is
>
> 2021-12-21 23:02:43.829 -04,,,36848,,61bf6ecf.8ff0,9,,2021-12-19 13:41:35
> -04,,0,LOG,0,"received SIGHUP, reloading configuration files",""
>
> No other error message
>
> --
Please don't top post; the convention here is to inline or bottom post and
trim unnecessary quoting.
On Tue, Dec 21, 2021 at 9:24 PM shing dong wrote:
>
> - remove
> yum remove postgresql*
>
> --- install
> yum -y install
> https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/p
*DEAR TOM*
just one PG instance in host
I did an experiment
When I remove pg and reinstall pg, the function of pg_hba is working
,represent that the location of pg_hba is right
- remove
yum remove postgresql*
--- install
yum -y install
https://download.postgresql.org/pub/repos/yum/repor
shing dong writes:
> 1. The rules in pg_hba.conf are almost invalid
> 2. pg_hba.conf is only useful for METHOD = trust
> 3. check SHOW hba_file; the file location is correct
> 4. select * from pg_hba_file_rules; checked is correct
> 5.DB version : PostgreSQL 10.19 on x86_64-pc-linux-gnu, compi
