Re: Connection string parameter "sslrootcert" does not work

On 11/11/2014 09:52 AM, Ed Hutchinson wrote:
> Thanks, Adrian.
>
>
> Sorry, I should have provided more details.
>

> I get back:
> root certificate file \"/Users/edhutch/.postgresql/root.crt\" does not
> exist\nEither provide the file or change sslmode to disable server
> certificate verification.

Have you tried doing a psql connection using a redirected sslrootcert to
determine if this a more general problem?

Have you tried to quote the path names?


>
> When I rename the pem file to root.crt and place it in the default
> location that the driver expects, the connection goes through fine.
>

>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com