Hi All ,
Thank you for all the replies , I think even if psql does not verify the
certificate , it still has to import it. I guess like David mentioned it
might have default certificates in the client and server.
Regards,
Shankar
On Tue, Aug 11, 2020 at 1:45 AM Tom Lane wrote:
> "David G. John
"David G. Johnston" writes:
> On Mon, Aug 10, 2020 at 10:54 AM Shankar Bhaskaran
> wrote:
>> How does psql import the server certificate?
> It works by default because both the server and client are usually
> installed from the same source and the same default certificate files are
> provided to
The convention on these lists is to inline or bottom-post.
On Mon, Aug 10, 2020 at 11:11 AM Martin Gainty wrote:
> cant you use keytool ?
>
That wasn't the question, the OP already indicated they can do this
successfully in JDBC.
David J.
On Mon, Aug 10, 2020 at 10:54 AM Shankar Bhaskaran
wrote:
> How does psql import the server certificate?
>
See:
https://www.postgresql.org/docs/12/libpq-envars.html
Namely the "PGSSL*" prefixed environment variables.
It works by default because both the server and client are usually
installed
Sent: Monday, August 10, 2020 1:53 PM
To: pgsql-general@lists.postgresql.org
Subject: Certficates
Hi All,
This is a very basic question . i have to import the server.crt on the client
side java trustore to connect using jdbc to postgres server secured by ssl.
But when i try psql from same machine
Hi All,
This is a very basic question . i have to import the server.crt on the
client side java trustore to connect using jdbc to postgres server secured
by ssl.
But when i try psql from same machine , it shows the connection as
encrypted . How does psql import the server certificate?
psql "post
