Re: psql connect over ssl load balancer - Mailing list pgsql-general

From Tom Lane
Subject Re: psql connect over ssl load balancer
Date
Msg-id 1293485.1653327159@sss.pgh.pa.us
Whole thread Raw
In response to psql connect over ssl load balancer  ("dzagashev@gmail.com" <dzagashev@gmail.com>)
Responses Re: psql connect over ssl load balancer
List pgsql-general
"dzagashev@gmail.com" <dzagashev@gmail.com> writes:
> 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.
> But standard psql client don't working:
> $ PGSSLMODE=require psql -h proxy.softvisio.net

That isn't going to work, because PG wraps the SSL handshake inside
its own protocol.  You could set up an SSL tunnel and let psql think
it's making a non-encrypted connection.

            regards, tom lane



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: list tablespaces named in custom format dump
Next
From: Durumdara
Date:
Subject: Can I start Update row in After Insert trigger function?