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