[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?