I have setup a 3 node cockroach cluster with a Loadbalancer( ha proxy) on AWS. The cluster is up and I am able to access cockroach DB via cockroach sql client from a remote machine. I have setup a secure cluster.
/usr/local/bin/cockroach sql --certs-dir=certs --host=188.8.131.52
warning: no current database set. Use SET database = to change, CREATE DATABASE to make a new database.
email@example.com:26257/> show “session_user”;
| session_user |
| root |
I am having trouble connecting via psql client on the remote machine. I have generated node certifcate for the remote node and client certificate[ root user ] , copied the node cert as root cert in the .postgresql directory , also have the client certs. I keep getting the error as below, please let me know what I am missing,
psql: SSL error: certificate verify failed