Re: How to confirm the pg_hba.conf service is correctly working

2021-12-23 Thread shing dong
uspect that the function of pg_hba is destroyed? Dave Cramer 於 2021年12月22日 週三 下午6:58寫道: > > > 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.

Re: How to confirm the pg_hba.conf service is correctly working

2021-12-21 Thread shing dong
on is very tricky Tom Lane 於 2021年12月21日 週二 下午10:42寫道: > 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

How to confirm the pg_hba.conf service is correctly working

2021-12-21 Thread shing dong
Hello all A while ago, our company had an Postgres DB that was Hacked login db to modify data found that pg_hba.conf is not work Any ip, user can log in to DB 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