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

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