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.
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
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