BUG #14006: psql cannot find client certificates in default location - Mailing list pgsql-bugs

From lupitheloop@gmail.com
Subject BUG #14006: psql cannot find client certificates in default location
Date
Msg-id 20160308150253.8901.83353@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14006
Logged by:          Loop
Email address:      lupitheloop@gmail.com
PostgreSQL version: 9.5.0
Operating system:   Windows Server 2012 R2
Description:

PostgreSQL documentation at
http://www.postgresql.org/docs/9.5/static/libpq-ssl.html
says that when a client certificate is requested by a server, a windows
client psql will use by default the credentials  located at
%APPDATA%\postgresql\postgresql.crt and %APPDATA%\postgresql\postgresql.key

However, my psql client application (v 9.5.0) in a Windows Server 2012 R2
cannot find the certificates in this location and only works when this
location is specifically set using the sslcert and sslkey attributes when
connecting. Is this a bug or am I using a wrong path?

This an example of execution:

-------------------------------------------
C:\Program Files\PostgreSQL\9.5\data> ..\bin\psql
"postgresql://postgres@localhost/postgres"
psql: FATAL:  connection requires a valid client certificate
FATAL:  no pg_hba.conf entry for host "::1", user "postgres",
database"postgres", SSL off

C:\Program Files\PostgreSQL\9.5\data> ..\bin\psql
"postgresql://postgres@localhost/postgres?sslkey=postgresql\postgresql.key&sslcert=postgresql\postgresql.crt"
psql (9.5.0)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384,bits:
256, compression: off)
Type "help" for help.
postgres=#
--------------------------------
cheers

pgsql-bugs by date:

Previous
From: manish.bhanumca@gmail.com
Date:
Subject: BUG #14005: Installation Error
Next
From: ryan.schannauer@vwr.com
Date:
Subject: BUG #14007: log_statement doesn't work when applied to a 'group'