On Fri, Jul 9, 2010 at 04:58, Craig Ringer <cr...@postnewspapers.com.au> wrote: > On 8/07/2010 6:31 PM, Magnus Hagander wrote: >> >> On Thu, Jul 8, 2010 at 03:10, Craig Ringer<cr...@postnewspapers.com.au> >> wrote: >>> >>> IIRC on Windows client certificates live in >>> >>> %APPDATA%\.postgresql\ >> >> That's a typo, it should be %APPDATA%\postgresql\ (no leading period). > > You're quite right. Sorry - I thought it used .postgresql as it does on > *nix, but a quick test confirms that it's: > > %APPDATA%\postgresql\postgresql.crt > %APPDATA%\postgresql\postgresql.key > >>>> (No one else here is using certs under Windows 7?) >>> >>> I use client certificates on Windows, but only via a Java app with JDBC, >>> so I haven't been too worried about libpq's client cert handling. >> >> It'd be great if you can check that it works in your environment, >> since you clearly have a working server-side and client-in-java env. >> If it doesn't work for you, that's a whole lot of thinsg we can rule >> out as the culprits then :-) > > I just set up a test, and it works fine with my win7 test box connecting to > a Linux server that requires a client cert to permit connections.
Ok, that's good. Then we k now it's not a generic issue on Win7, but must be something specific to the OP's problem. Did you also, or could you also, test the connection parameters and/or environment variables that tells libpq to look for the certificate in a different location? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs