Re: SSL Connection Issue

[Andreas Pflug <pgadmin(at)pse-consulting(dot)de>]

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