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

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 <s7eqs7eq(at)gmail(dot)com> wrote:

>
> ----- remove
> yum remove postgresql*
>
> --- install
> yum -y install
> https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
>
> yum install postgresql10 postgresql10-server postgresql10-contrib
> postgresql10-libs postgresql10-dev* -y
>

Frankly, if you did this and you are still seeing errors, start over on a
fresh, never hacked, machine. Test that the new machine is secure then
restore your backup into it.

-----------
> I have Check again the content of pg_hba.conf and "select * from
> pg_hba_file_rules" consistent
>

If you want to continue having a public debugging session (on the problem
machine) I suggest that you perform all queries and inspect all files using
a terminal and then provide, with some light editing only, a copy of the
terminal transcript for evaluation.

You may wish to stand up a clean machine (VM or otherwise) for debugging,
just to ensure that your experiments produce the expected results.

David J.