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