Location of certs -Windows 7 SSL mode? - Mailing list pgsql-testers

From Lou Picciano
Subject Location of certs -Windows 7 SSL mode?
Date
Msg-id 323E0FB3-767F-457F-A041-908B0A805C68@comcast.net
Whole thread Raw
Responses Re: Location of certs -Windows 7 SSL mode?  (Magnus Hagander <magnus@hagander.net>)
List pgsql-testers
[TEST REPORT]
[Release]: 9.0Beta2
[Test Type]: Testing connection - pgAdmin - using certificate on Windows 7 - Specifically, what is correct default placement of certs?
[Test]: Attempt to connect - SSL required or better - using standard AppData/Roaming location for certs, key.
[Platform]: Windows 7 Ultimate 64-bit - attempting connection using pgAdminIII as a test of SSL connectivity.
[Parameters]: First, attempted connection, with SSL required and NO certs, to determine default location based on error message!
[Failure]: Yes
[Results]: Installation of a pre-packaged PostgreSQL, using an installer (in this case a b1 packaged by EnterpriseDB), did create a postgresql folder in the expected location: C:\Users\<username>\AppData\Roaming\postgresql.  After placement of valid certs and key in this folder, cannot connect in any SSL mode.
Interestingly, the error message reverses the pathname delimiter, halfway through the message, from Windows-standard to UNIX-standard (is this relevant?)...
"Error connecting to the server: could not open certificate file "C:\Users\<username>\AppData\roaming/postgresql/potgresql.crt": No such file or directory.
[Comments]: Again, perhaps the joys of the Windows 'security' model?

pgsql-testers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: R: [ADMIN] Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?
Next
From: Magnus Hagander
Date:
Subject: Re: Location of certs -Windows 7 SSL mode?