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

From dzagashev@gmail.com
Subject Re: psql connect over ssl load balancer
Date
Msg-id 645879a4-1c4b-2d83-3946-8999d51b2029@gmail.com
Whole thread Raw
In response to Re: psql connect over ssl load balancer  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Ah, thanks.
This will make thing more complex.

On 23.05.2022 20:32, Tom Lane wrote:
> "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: Durumdara
Date:
Subject: Can I start Update row in After Insert trigger function?
Next
From: Adrian Klaver
Date:
Subject: Re: Can I start Update row in After Insert trigger function?