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.

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
------------------
 *
`

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.

postgres@dvzsn-rd5482:> hostname -I
10.4.91.68
postgres@dvzsn-rd5482:> 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 ...

postgres@dvzsn-rd1941:> 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

 postgres@dvzsn-rd1941:> psql -c "SHOW listen_addresses"
 listen_addresses
------------------
 *
`