psql and jdbc default sslmode

Hi , We are making connections to the postgres server through jdbc and psql (libpq) . I have set the ssl as on the postgres server . It can take ssl as well as non ssl connections. I made a connection through a psql client to postgres server and could confirm that the default sslmode (when no sslm

Re: Certficates

;David G. Johnston" writes: > > On Mon, Aug 10, 2020 at 10:54 AM Shankar Bhaskaran < > mailshank...@gmail.com> > > wrote: > >> How does psql import the server certificate? > > > It works by default because both the server and client are usually > > insta

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 , it shows the connection as encrypted . How does psql import the server certificate? psql "post

Configuring only SSL in postgres docker image

Hi , I am trying to enable ssl on postgres docker image . The postgres image should only support SSL . I did configure the command:" -c ssl=on -c ssl_key_file=/opt/postgresql/server.key -c ssl_cert_file=/opt/postgresql/server.crt" in the docker compose file. I also added the following entry in

Version 10.7 of postgres

Hi , We are planning to use postgres 10.7 version as that is the latest version supported on Aurora DB. Since we have an on premise installation also , i was trying to download the same version of postgres for windows and linux. Unfortunately that version is not available in the download site as w