Good Day All!
I setup my postgres servers to allow certificate authentication. Right now I have two database servers and one application server. Users are only allowed to connect into the application server, invoke psql, then connect into which ever database server they want. I have the keys and certs for db server 1 in their .postgresql folder under their home and it works fine, but i can't figure out how to properly setup the environment so that they can connect into either db server with the keys. I tried to merge the key/cert files in their .postgresql directory with info for both db servers but that didn't work. I feel like there is an obvious solution to this that I can't see. Any ideas?