Fwd: pgAdmin 4 MacOS with client-certificates: on import qsql does not set the required sslcert and sslkey

---------- Forwarded message ---------
From: Fabian Sturm <fabian(dot)sturm(at)aduu(dot)de>
Date: Wed, Feb 13, 2019 at 1:31 AM
Subject: Re: pgAdmin 4 MacOS with client-certificates: on import qsql does
not set the required sslcert and sslkey
To: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>

Hello Khushboo,

The workaround works! I reported the problem.

Thanks,
Fabian Sturm

Am 12.02.2019 um 06:35 schrieb Khushboo Vashi <
khushboo(dot)vashi(at)enterprisedb(dot)com>:

Hi,

On Mon, Feb 11, 2019 at 7:37 PM Fabian Sturm <fabian(dot)sturm(at)aduu(dot)de> wrote:

> Hello,
> I’m playing around with pgAdmin 4, just got client certificates working.
> After that I exported some test data from another database and recreated
> the same table in my remote database which uses client-certificates.
> Then I tried to import the rows in the remote database, which as far as I
> can tell failed since pgAdmin 4.2 does not add sslcert and sslkey to the
> psql call.
>
> The problem is illustrated in the following images. Connection dialog.
> Import dialog. Error message showing failing psql command.
> https://imgur.com/a/bCK7SX4
>
> My platform is 10.14.4 Beta (18E174f) and I’m using pgAdmin 4.2.
>
> Is there a setting to make psql use the given sslcert and sslkey? Or did I
> do sth wrong?
>
> This is a bug in pgAdmin 4, please log this issue @
https://redmine.postgresql.org/projects/pgadmin4
For the workaround, if you can set `Root Certificate` in the server
connection, then it should work.

> Regards, Fabian Sturm
>

Thanks,
Khushboo