Postgres Pro
Downloads
Home   >   mailing lists

Re: pgAdmin 4 MacOS with client-certificates: on import qsql does notset the required sslcert and sslkey - Mailing list pgadmin-support

From Khushboo Vashi
Subject Re: pgAdmin 4 MacOS with client-certificates: on import qsql does notset the required sslcert and sslkey
Date
Msg-id CAFOhELfV1JYuC51HZNNQW0KzH+a9WE4ZbqPb2EZPuB56KogW8w@mail.gmail.com
Whole thread Raw
In response to pgAdmin 4 MacOS with client-certificates: on import qsql does not setthe required sslcert and sslkey  (Fabian Sturm <fabian.sturm@aduu.de>)
List pgadmin-support
Tree view
Hi,

On Mon, Feb 11, 2019 at 7:37 PM Fabian Sturm <fabian.sturm@aduu.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 

pgadmin-support by date:

Previous
From: Fabian Sturm
Date:
Subject: pgAdmin 4 MacOS with client-certificates: on import qsql does not setthe required sslcert and sslkey
Next
From: Malik Rumi
Date:
Subject: Either Find does not work or I don't know how to make it work