I want to connect to `postgres-12` from a `postgres-14` server in order to get dumps from the remote. Apparently there is a connection problem when trying to access the remote postgres server though. ```bash postgres@dvzsn-rd5482:/opt/db/postgres/bin> hostname -I 10.4.91.68 postgres@dvzsn-rd5482:/opt/db/postgres/bin> psql -p 5449 -h 10.4.91.32 psql: error: connection to server at "10.4.91.32", port 5449 failed: FATAL: no pg_hba.conf entry for host "10.4.91.68", user "postgres", database "postgres", SSL off ``` so it complains about a missing `pg_hba.conf` entry on the remote for `10.4.91.68` however ... ``` psql -p 5449 -c "SELECT * FROM pg_hba_file_rules WHERE address = '10.4.91.68';" line_number | type | database | user_name | address | netmask | auth_method | options | error -------------+-----------+------------+------------+------------+-----------------+-------------+---------+------- 92 | host | {all} | {all} | 10.4.91.68 | 255.255.255.255 | md5 | | 93 | hostnossl | {postgres} | {postgres} | 10.4.91.68 | 255.255.255.255 | md5 | | (2 rows) ``` in my eyses the first line should be sufficient even. Any idea on what I am not seeing? It does not seem to be `listen_addresses` ``` psql -c "SHOW listen_addresses" listen_addresses ------------------ * `