Re: SSL Connection Issue
Andreas Pflug <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32 |
|---|---|
| Message-ID | <[email protected]> |
Magnus Hagander wrote: > > >>I am connecting to the server from the same computer as where >>the server is running. Just local... The log of the server >>gives this (with >>log_error_verbosity=verbose): >> >>------------------------------------------------------ >>C:\Documents and Settings\postgresql>postmaster >>LOG: could not recognize system timezone, defaulting to "Etc/GMT-1" >>HINT: You can specify the correct timezone in postgresql.conf. >>LOG: could not load root certificate file >>"C:/postgres/data/root.crt": No such >>file or directory > > > ^^^ > This here is your problem. There is no root certificate for it to load. > You need to either adjust the path to wherever you have your root > certificate, or move the root certificate to the specified location. > No, AFAIR root.crt is necessary for client certificates only. My Linux installation works perfectly without. server.req, server.key and server.crt are in my PGDATA dir. Regards, Andreas ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [email protected]