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
Last activity: Jan 25, 2024, 06:40 AM