Re: psql connect over ssl load balancer

Поиск
Список
Период
Сортировка
От dzagashev@gmail.com
Тема Re: psql connect over ssl load balancer
Дата
Msg-id 645879a4-1c4b-2d83-3946-8999d51b2029@gmail.com
обсуждение исходный текст
Ответ на Re: psql connect over ssl load balancer  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Durumdara
Дата:
Сообщение: Can I start Update row in After Insert trigger function?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Can I start Update row in After Insert trigger function?