Re: PostgreSQL in-transit compression for a client connection

2023-04-28 Thread Dominique Devienne
On Fri, Apr 28, 2023 at 9:03 AM Magnus Hagander wrote: > On Thu, Apr 27, 2023 at 11:55 AM Laurenz Albe > wrote: > > > > On Thu, 2023-04-27 at 11:44 +0200, Dominique Devienne wrote: > > > as someone who must store ZLIB (from ZIP files) > > > and sometimes LZ4 compressed `bytea` values, I often fi

Re: PostgreSQL in-transit compression for a client connection

2023-04-28 Thread Magnus Hagander
On Thu, Apr 27, 2023 at 11:55 AM Laurenz Albe wrote: > > On Thu, 2023-04-27 at 11:44 +0200, Dominique Devienne wrote: > > as someone who must store ZLIB (from ZIP files) > > and sometimes LZ4 compressed `bytea` values, I often find it's a shame that > > I have > > to decompress them, send them ov

Re: PostgreSQL in-transit compression for a client connection

2023-04-27 Thread Laurenz Albe
On Thu, 2023-04-27 at 11:44 +0200, Dominique Devienne wrote: > as someone who must store ZLIB (from ZIP files) > and sometimes LZ4 compressed `bytea` values, I often find it's a shame that I > have > to decompress them, send them over the wire uncompressed, to have the > PostgreSQL > backend reco

Re: PostgreSQL in-transit compression for a client connection

2023-04-27 Thread Dominique Devienne
On Thu, Apr 27, 2023 at 11:24 AM Laurenz Albe wrote: > On Thu, 2023-04-27 at 14:48 +0530, Tushar Takate wrote: > > Does PostgreSQL support in-transit compression for a client connection? > > No, not any more. > On a related but different subject, as someone who must store ZLIB (from ZIP files) a

Re: PostgreSQL in-transit compression for a client connection

2023-04-27 Thread Laurenz Albe
On Thu, 2023-04-27 at 14:48 +0530, Tushar Takate wrote: > Does PostgreSQL support in-transit compression for a client connection? No, not any more. There used to be compression via SSL, but that was removed for security reasons, and because most binary distributions of OpenSSL didn't support it a

Re: PostgreSQL in-transit compression for a client connection

2023-04-27 Thread Daniel Gustafsson
> On 27 Apr 2023, at 11:18, Tushar Takate wrote: > Does PostgreSQL support in-transit compression for a client connection? No. Earlier versions supported SSL compression for encrypted connections but that rarely worked as it was disabled in the vast majority of all OpenSSL installations. There

PostgreSQL in-transit compression for a client connection

2023-04-27 Thread Tushar Takate
Hi Team, Does PostgreSQL support in-transit compression for a client connection? *If yes*, Then please help me with the below. 1. 1. What are the different methods? 2. 2. How to enable/use it? Thanks & Regards, Tushar K Takate.