Requirement is to use only ca.crt and connect to postgres Server.crt, Server.key and ca.crt are configured at the postgres server for tls connection.
Connection successful while using psql ‘host=172.29.21.222 dbname=test user=postgres sslmode=verify-ca sslcert=/tmp/server.crt sslkey=/tmp/server.key sslrootcert=/tmp/ca.crt port=5432’ For clients to connect, can they use only ca.crt and connect to the DB. Tried and got the below error psql ‘host=172.29.21.222 dbname=test user=postgres sslmode=verify-ca sslrootcert=/tmp/ca.crt port=5432’ psql: error: connection to server at “172.29.21.222”, port 50001 failed: FATAL: connection requires a valid client certificate
