| From: | "dzagashev(at)gmail(dot)com" <dzagashev(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: psql connect over ssl load balancer |
| Date: | 2022-05-23 17:40:34 |
| Message-ID: | 645879a4-1c4b-2d83-3946-8999d51b2029@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Ah, thanks.
This will make thing more complex.
On 23.05.2022 20:32, Tom Lane wrote:
> "dzagashev(at)gmail(dot)com" <dzagashev(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2022-05-23 17:41:56 | Re: Can I start Update row in After Insert trigger function? |
| Previous Message | Durumdara | 2022-05-23 17:35:59 | Can I start Update row in After Insert trigger function? |