[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!
[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-bugs by date
|Next:||From: Craig Ringer||Date: 2010-07-07 01:34:51|
|Subject: Re: BUG #5542: Query optimization problem|
|Previous:||From: Tom Lane||Date: 2010-07-06 20:52:16|
|Subject: Re: ERROR: cannot handle unplanned sub-select |
pgsql-testers by date
|Next:||From: Magnus Hagander||Date: 2010-07-07 08:50:03|
|Subject: Re: [TESTERS] Location of certs -Windows 7 SSL mode?|
|Previous:||From: Bruce Momjian||Date: 2010-06-23 20:04:22|
|Subject: Re: [TESTERS] R: Postgresql 9.0b2 : pg_upgrade not
passing username to pgdumpall ?|