Sample Header Ad - 728x90

remote connection not working despite pg_hba.conf entry

0 votes
1 answer
265 views
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 ------------------ * `
Asked by vrms (269 rep)
Jan 23, 2024, 11:23 AM
Last activity: Jan 25, 2024, 06:40 AM