Re: SSL Certificates in Windows 7 & Postgres 9.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: SSL Certificates in Windows 7 & Postgres 9.3
Date
Msg-id 23726.1418687388@sss.pgh.pa.us
Whole thread Raw
In response to Re: SSL Certificates in Windows 7 & Postgres 9.3  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: SSL Certificates in Windows 7 & Postgres 9.3
List pgsql-general
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 12/15/2014 02:36 PM, harpagornis wrote:
>> 2014-12-15 22:28:06 GMT FATAL:  connection requires a valid client
>> certificate
>> 2014-12-15 22:28:06 GMT FATAL:  no pg_hba.conf entry for host "127.0.0.1",
>> user "SYSTEM", database "postgres", SSL off

> Well something is trying to connect not using SSL.

It might be that libpq is trying an SSL connection, it's not working,
and it immediately tries a non-SSL connection.  It'd likely be worth
turning on log_connections to help debug this --- I think, but not
totally sure, that would record any such extra connection attempt.

> The question then is who is "SYSTEM" user?

Yeah, that looks pretty fishy.

            regards, tom lane


pgsql-general by date:

Previous
From: David G Johnston
Date:
Subject: Re: SSL Certificates in Windows 7 & Postgres 9.3
Next
From: Adrian Klaver
Date:
Subject: Re: SSL Certificates in Windows 7 & Postgres 9.3