Re: SSL Certificates in Windows 7 & Postgres 9.3

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