Hi Merkel,
Can you please share the exact steps to reproduce and screenshot?
I am getting the following error message on psql (command-line tool for PostgreSQL) for verify-full option:
psql.bin: root certificate file "/root/.postgresql/root.crt" does not exist
Either provide the file or change sslmode to disable server certificate verification.
Can you please try your error message through psql
----
Steps
1.go into PostgreSQL binary path and execute this command
export PGSSLMODE=verify-full
2. no connect with psql
[root@localhost bin]# ./psql -U postgres -h localhost -p 5432 -d postgres
psql.bin: root certificate file "/root/.postgresql/root.crt" does not exist
Either provide the file or change sslmode to disable server certificate verification.
If you are getting the same error message through psql then it is not an issue with pgadmin4.
Hello,
the pgadmin 6.8 software does support SSL mode Verify-Full on connect.
But how is it possible to use a password protected client certificate key file to connect? (without password works)
There is no prompt shown on connect nor could I find any other way to provide the password for the key.
The whole application gets stuck in “connecting” to server for forever, so it’s also kind of a bug here(?)
Best regards,
Christian Merkel
--
Fahar Abbas
pgAdmin4 team
Mobile: +92-333-5409707
Skype ID:
live:fahar.abbasWebsite:
www.enterprisedb.com