Sample Header Ad - 728x90

need help understanding the error-message: Error Connecting to database FATAL : no pg_hba.conf entry

0 votes
2 answers
10318 views
We're trying to connect to a postgres/postgis installation on a remote server, using QGIS-Application. When accessing from another pc or from the same pc via pgadmin4v4 with the same credential/authentification settings, it works just fine. Therefore I conclude the pg_hba.conf is ok and it's in fact a problem of QGIS. In order to better understand the problem and maybe file a bug for QGIS I need help analysing the error message. It sais:
Area: dbname = , host , port 5432, user , password , authcfg = 

SSL error: certificate verify failed
FATAL: no pg_hba.conf entry for host , user , database , SSL off
My main questions: 1. shouldn't the host-ip addresses be identical? Could it be part of the problem, that the second ip mentioned is not the correct server-ip? As far as I can see, there should be only one host (remote server) and one client involved (pc trying to get access). 2. why doesn't it say "no pg_hba.conf entry for **client** ..." 3. does QGIS think is it is a certificate problem, or a pg_hba.conf problem, or is that both the same *Update: further Details about the installation* - Client-PC1: Win10, QGIS 3.4 [error] pgAdmin 4v4 [access ok] - Client-PC2: Win10, QGIS 3.10 [access ok] pgAdmin 4v4 [access ok] - Server: postgres 12 - pg_hba.conf:
# Database administrative login by Unix domain socket
local   all             postgres                                peer

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             0.0.0.0/0               scram-sha-256
# IPv6 local connections:
hostssl all             all             ::0/0                   scram-sha-256
Asked by xof (35 rep)
Apr 8, 2020, 08:42 AM
Last activity: Apr 8, 2020, 04:32 PM