From: | "dzagashev(at)gmail(dot)com" <dzagashev(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | psql connect over ssl load balancer |
Date: | 2022-05-23 17:28:15 |
Message-ID: | e6204c31-9d66-4c40-1db0-91444a8aa635@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi.
I want to secure connections to postgress server usings SSL.
My server is deployed on google cloud behind SSL load balancer, which
terminates SSL connections (using SSL certificates, issued by google)
and forwards decrypted traffic to the posgres server.
I can connect without problems from nodejs using TLS socket.
But standard psql client don't working:
$ PGSSLMODE=require psql -h proxy.softvisio.net
psql: error: connection to server at "proxy.softvisio.net"
(34.149.158.159), port 5432 failed: server closed the connection
unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Seems, that psql will not work withour private keys? But I am not sure.
Could somebody help me to understand, how I can use it?
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-05-23 17:29:18 | Re: list tablespaces named in custom format dump |
Previous Message | Rob Sargent | 2022-05-23 17:19:21 | Re: list tablespaces named in custom format dump |