On = Wed, 16 Jun 2021 at 13:41, Massimo Ortensi <mortensi@unimaticaspa.it> wrote:

=20 =20 =20

is there any way to compress the traffic for streaming replication ?

I think=C2=A0= this should help reduce traffic as it would decompress only when replaying.=

I have not used it, but now that you asked, I will test it=C2=A0= out.

PostgreSQL: Documentation: 13: 19.5.=C2=A0W= rite Ahead Log

Also, pg_basebackup support= s gzip stream, and so does COPY but I do not see exclusive mention of compr= ession support in replication slot details.

But if you try having= a sidecar like envoyproxy=C2=A0or any tcpproxy per server, maybe communica= tion between sidecars can be compressed but not db to sidecar.

Gzip Compressor =E2=80=94 envoy 1.19= .0-dev-069478 documentation (envoyproxy.io)=C2=A0 (this is not pg stuff= but ... )

[pg -> sidecar -> compressed = wal stream]=C2=A0 -> [sidecar -> decompress -> pg]

I hav= e not tried any option, FYI.

Thanks,

Vijay

Mumbai, India

--000000000000df3f6705c4e34370-- From vijaykumarjain.github@gmail.com Wed Jun 16 14:55:39 2021 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ltWxO-0002n0-Dj for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jun 2021 14:55:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ltWxN-0001HE-Ax for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jun 2021 14:55:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ltWxN-0001H5-0s for pgsql-admin@lists.postgresql.org; Wed, 16 Jun 2021 14:55:53 +0000 Received: from mail-lf1-x12c.google.com ([2a00:1450:4864:20::12c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ltWxL-0000nw-1g for pgsql-admin@postgresql.org; Wed, 16 Jun 2021 14:55:52 +0000 Received: by mail-lf1-x12c.google.com with SMTP id x24so4788710lfr.10 for ; Wed, 16 Jun 2021 07:55:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=dV4SujT8hVRzgmD4Ac/YUv9uZtn5AzWH69LjCy/k/Wk=; b=gZsMVE4TQhBd6BxxvN0YqItkZlXfbY9mvGCgIBkmOie+rYBbKVcrrXsNca5WQDOARg HcnmmJ/bZWqni435x3Lvklf5MovdPZr1q+8u5dXtsCuHpM82BYo7dMZ2v+K2r0bYLgcb JYvYrtcWWpp/MzLzmR3gKYAKB9YK3wdMn6D3aAlq8CvUsOvhKylnAryUe+pXb6+A0NTk Opr/eiCyM1ynAU9HZ/f0s2bHjYOpjE8N7uuxQYIqEcfeqen7Gnch26hzP4xL6whs0Vpf yvCfB3LfBLm0l6RljoCN8nsIuxA7MXvqJ26J++U9pOjW6x2G7LQMlqaZ4OrOhDFr+by3 +omw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=dV4SujT8hVRzgmD4Ac/YUv9uZtn5AzWH69LjCy/k/Wk=; b=a2hJNpxCa+BV4r1U89QS8oVN+LxoAiK3k/Ab9R4HyxRRqw5D3G3z1qbWTzidHP0kYt WJ0xFPB4j/hKffLMVJ+B5Ay5KjgdX8zUlWXcGwb6JUEjBjmkraLgEL2H+VLVusHI9nVY cZsCCkGVYUSwYUywAJIhJPRo7VPlfK5xCYLadSVX73JDuBosflI5cyLK/O8CDgcO2KmS dD8BHVWk2HLucZeFtexBsWi4DPaISPUlsdCYouz6tcbTeuALl4hYu9aLBH3u+C8INuna dAEpLvYCqrtGxFpJYOQ5ABqHbh7/m5N6JjtmG5u/yuDVn4clwHoQutSN+P41omLRgcvG cRug== X-Gm-Message-State: AOAM531zBjCve/tdatPEZwZtLkPZNTrfaY8lGCHp7tNIg5a68RxEaOO5 YI4FfIRWO7Wj50DS2M/ehq6zKlWHIaTVsyHiZXwnCFNrkE8= X-Google-Smtp-Source: ABdhPJyHfo5hviIYL3MzEiJDpEMxezskw/bq91trMtO5d5MIreboHlujM+c22I0ypnUL7UoOL1FP/racX7lILpBSkQY= X-Received: by 2002:a19:dc5e:: with SMTP id f30mr74731lfj.318.1623855349331; Wed, 16 Jun 2021 07:55:49 -0700 (PDT) MIME-Version: 1.0 References: <1ltQeA-000URA-EE@unimaticaspa.it> In-Reply-To: From: Vijaykumar Jain Date: Wed, 16 Jun 2021 20:25:39 +0530 Message-ID: Subject: Re: compression in replication To: Massimo Ortensi Cc: pgsql-admin Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk sorry, the link was broken. this was the param. "wal_compression (boolean) When this parameter is on, the PostgreSQL server compresses a full page image written to WAL when full_page_writes is on or during a base backup. A compressed page image will be decompressed during WAL replay. The default value is off. Only superusers can change this setting. Turning this parameter on can reduce the WAL volume without increasing the risk of unrecoverable data corruption, but at the cost of some extra CPU spent on the compression during WAL logging and on the decompression during WAL replay." From mortensi@unimaticaspa.it Wed Jun 16 15:00:59 2021 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ltX2x-000310-Hf for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jun 2021 15:01:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ltX2R-0005ao-03 for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jun 2021 15:01:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ltX2Q-0005ag-I8 for pgsql-admin@lists.postgresql.org; Wed, 16 Jun 2021 15:01:06 +0000 Received: from mail.unimaticaspa.it ([89.97.230.136]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ltX2M-0001Ca-El for pgsql-admin@postgresql.org; Wed, 16 Jun 2021 15:01:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=simple/simple; d=unimaticaspa.it; s=mail; h=Message-Id:Content-Type:In-Reply-To:MIME-Version :Date:From:References:To:Subject:Sender:Reply-To:Cc:Content-Transfer-Encoding :Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=HcqgVsPbWO35YbO2B3aiNJRM54L1fJJb98d1YW9gWbA=; b=RNsNW5n99Vs3axM25B2bR3TC4e wZ2cYWdyeJlgU32fPjaxADJstTj9JWKi0uIeV/cX/9rO/BwdXNFTnyZA53I/uijQbrVwKS2nEXAEi jj9hWYVeNctgnWfA0OdEpXL/1bHqeY1ZhkC9DI1wFjjV6xA4LuAY0eVTnPCC5lHAe5CXLCD3GYnoK tZ9eh0+eI6hk6MArJF64/XqhFTvTjWqxgKVFVvQeYUPRwRpCvFYII4/s8hz92AD0E68/4dccA/PpK 9zhZ7qBEUMWKNGTryGWn23+8e1Rct5cEaIOjjXS/fQ67Y1fscgYNJkJqF1liLk/B0Waept04DtqW5 oXJJUZleFXmUYBxwCFZNR6Xg7/QBfm7jTgIv+ogdeD7jl5b34ljCNkFI3OOVFbr3o7CqLZVkjG4OH 2EbA4CZF6vI8+fevK3NjTBF7E92IqBK/hvK/TN24Q87TUS/LZT1NzKvngypZaPLE0yyz9/XzAlRak /NMuXZA61seBIhoPIIsldU1AcRnaaQ1iQwgPdKqTptF+JGhFDhuTVwHfkZl33rE4bmEr5+XhSI7lk EgnbtBmivdCQZtS7yOOd7SIdbKWjLTsy0hSL5OHqa7RCWnK4K4AwCoXd61mPwAO5GghtBDcLFtc9V yQ3wUphmclHi5fQZnjOsi8Hg52T27Dq3qCqlOmk6U=; Received: from pc-ortensi.unimatica.lan ([10.143.90.16]) by mail.unimaticaspa.it with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94) (envelope-from ) id 1ltX2K-0000Eb-BV for pgsql-admin@postgresql.org; Wed, 16 Jun 2021 17:01:00 +0200 Subject: Re: compression in replication To: pgsql-admin References: <1ltQeA-000URA-EE@unimaticaspa.it> From: Massimo Ortensi Date: Wed, 16 Jun 2021 17:00:59 +0200 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Thunderbird/78.11.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/related; boundary="------------1553ED15CC70BAB9B8EB79B2" Content-Language: it X-Unimatica-LocalUser: true Message-Id: <1ltX2K-0000Eb-BV@unimaticaspa.it> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------1553ED15CC70BAB9B8EB79B2 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

I tried with wal_compression=on but seems to have no effect

Massimo Ortensi - Responsabile ICT

Via Cristoforo Colombo, 21 - 40131, BolognaÂ
Tel.Â 051 4195069
Cell.Â 3351092560

mortensi@unimaticaspa.it

Il 16/06/2021 16.54, Vijaykumar Jain ha scritto:

On Wed, 16 Jun 2021 at 13:41, Massimo Ortensi <mortensi@unimaticaspa.it> wrote:

is there any way to compress the traffic for streaming replication ?

--

I thinkÂ this should help reduce traffic as it would decompress only when replaying.

I have not used it, but now that you asked, I will test itÂ out.

PostgreSQL: Documentation: 13: 19.5.Â Write Ahead Log

Also, pg_basebackup supports gzip stream, and so does COPY but I do not see exclusive mention of compression support in replication slot details.

But if you try having a sidecar like envoyproxyÂ or any tcpproxy per server, maybe communication between sidecars can be compressed but not db to sidecar.

Gzip Compressor â envoy 1.19.0-dev-069478 documentation (envoyproxy.io)Â (this is not pg stuff but ... )

[pg -> sidecar -> compressed wal stream]Â -> [sidecar -> decompress -> pg]

I have not tried any option, FYI.

--

Thanks,
Vijay

Mumbai, India

--------------1553ED15CC70BAB9B8EB79B2 Content-Type: image/jpeg; name="UnimaticaSPA.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: inline; filename="UnimaticaSPA.jpg" /9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAAeAAD/4QODaHR0 cDovL25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1 TTBNcENlaGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5z Om1ldGEvIiB4OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjYtYzE0MiA3OS4xNjA5MjQsIDIw MTcvMDcvMTMtMDE6MDY6MzkgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDov L3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRp b24gcmRmOmFib3V0PSIiIHhtbG5zOnhtcFJpZ2h0cz0iaHR0cDovL25zLmFkb2JlLmNvbS94 YXAvMS4wL3JpZ2h0cy8iIHhtbG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8x LjAvbW0vIiB4bWxuczpzdFJlZj0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBl L1Jlc291cmNlUmVmIyIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAv IiB4bXBSaWdodHM6TWFya2VkPSJGYWxzZSIgeG1wTU06RG9jdW1lbnRJRD0ieG1wLmRpZDo5 RjVGQUM0REQwNzIxMUU3OUVGMjhENTY5RTA2MkUxMCIgeG1wTU06SW5zdGFuY2VJRD0ieG1w LmlpZDo5RjVGQUM0Q0QwNzIxMUU3OUVGMjhENTY5RTA2MkUxMCIgeG1wOkNyZWF0b3JUb29s PSJBZG9iZSBQaG90b3Nob3AgNy4wIj4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3Rh bmNlSUQ9InV1aWQ6OWEzN2QwNWMtNjNlZi0xMWRmLWI1OTEtODhmYjNiMDkyY2NkIiBzdFJl Zjpkb2N1bWVudElEPSJhZG9iZTpkb2NpZDpwaG90b3Nob3A6NmY3MTZlNzAtNjNlYS0xMWRm LWI1OTEtODhmYjNiMDkyY2NkIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwv eDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+/+4ADkFkb2JlAGTAAAAAAf/bAIQAEAsL CwwLEAwMEBcPDQ8XGxQQEBQbHxcXFxcXHx4XGhoaGhceHiMlJyUjHi8vMzMvL0BAQEBAQEBA QEBAQEBAQAERDw8RExEVEhIVFBEUERQaFBYWFBomGhocGhomMCMeHh4eIzArLicnJy4rNTUw MDU1QEA/QEBAQEBAQEBAQEBA/8AAEQgAggGkAwEiAAIRAQMRAf/EAKwAAQABBQEAAAAAAAAA AAAAAAAGAQMEBQcCAQEAAwEBAAAAAAAAAAAAAAAAAgMEAQUQAAIBAwEEAwwIBgICAgMAAAEC AwARBAUhMRIGQRMUUWFxgZGh0SIyklNUscFCUmJygiOistKTFRYzQ8IkY3M0RDURAAEEAAMF BQcBBwUBAAAAAAEAEQIDIRIEMUFRYVJxkaEiE4GxwTJCYhQj8NHh8ZIzU3KConMVY//aAAwD AQACEQMRAD8A6BSlKIlKUoiUpSiJSlKIlKUoiUpSiJSrc00WPE887iOKMFndjZVA3kmtDm6v nZIYYobEi4OsjDALkTIbqrfuArCjNsuwLbvVWiLfySxxLxyuqL95iFHlNY66rpbNwrmQFu4J UJ/mqNdnxo5hLkLEzsyOvaQZpmQe0rdcXc3va6LbZcb69tPhGV8dnj49r9S0TbFuGtY443L5 u5RFLFZWAZSCDtBG0VWolFDDHfJxD1AuA0mG4RU9piWReONrbFVHUXrZYmtSwHqtT4TGGEXb kHCiyMARHOtzwNt9oEoT0g7KIt3SrU2RjwWM8qRBtil2C3I7l6t/5DA+ah/uL6a6Ik7AVxxx WTSsft+D8zF/cX01Xt2F8xF76+mmWXAo44q/SrHbcP48fvr6ar2vE+PH76+mmU8Cjjir1Ktd qxvjJ7w9NO04/wAVPeFGPArrhXaVb7RB8RPeFOuh+IvlFGPBHVyleOti++vlFV6xPvDyiuMi 9UrzxL3R5arcd2iKtKpWp1rW308dTi40mVlEXsqMY0B6XZR5h5qlCEpnLEOVwkAOVtt201jv qWnRnhkyoUbuNIoPnNQHNn13UGJy1yHU7oxG6RjwIo+msQYOYN2LKPBE3orZHRBvNYH+1UHU HdHvXTIcvFn/AOCaOX8jq30Gr1ct7DmA8Qxpgw3MI3B8oFbjTda5gwGCvDPlY43xSo/EB+CT hv5b1yeiYPCYlyOC7G9/miRzU6pWPhZkebjrPGroDsZJFKOrDeCGrIrGQQWOBCvBdKUpXESl KURKUpREpSlESlKURKUpREpSlESlKURKUpREpSlESlKURKUpREpSsLWMp8TTZ5otk3DwQ/8A 2SERx/xMKItbkTf5HKMpXrcPGl6nDx/s5OWh9aVz9yIg+MFuhaxUSTU/383rMjH9fsqqpI4r 2WUqu1SxF0+6tunbV3LjOJiNjYps8SLp+G2zY7rxzS+Gw81YJz2hxdM0/GkkiAhEkk6sbM3V FurNrXIuNnF4qIqIW07Mglb1cjGDrYbXyhOP2ldumTrU4XPTa9ZNkxMrG1c5C5cEksjhVAUG ScBC0O1ibBT6u9vDYVr5lllyIyWkyHZgnHf10DyJFxLx33cdZ5MXVS4zRhm7aGhUpxI7FlVw wG08FiDbZRFe1GTF1TUBFjKrpAqvkyRH96VZP+r1fWaMLtcdOxe7XkGXCcYqRl9NyCyR4koA FmUkxhGHqrIoPADuYcO5tnjHSDFj1N4g0edLO+FiMtusFlDqE6w2C3JarebNlPgJCC3+Sw85 OrViHPCXLRgtchr2t4aIstMWDKxzok7GXFnj6/SshtrKq/8AWS23iiuO+V37jUTbFlhleGWE iSNijgISLrs2G1SvKkU4Zzccf8HV6pjqNpCnZkJ4CvF5akasGUMpupFwe8a0UamVQIbMDizs yqsqEyC7Fc1SJvhN7h9FX0jPw29w+iuiUqw61/o/5fwUfx/u8FAUjPwz7h9FXkjPwz7p9FTi lROrf6fFd9Hn4KGoh+4fdPoq8iH7h90+ipZSonUP9Piu+lzUaRT90+6avIp+6fIa39KibuXi penzWmRT90+SryDveatnSomx9y7l5rCQd6r6VepUTJdZeGkjjA43VL7uIgfTXntOP8VPeFQL mvMTK1mVCwKYoEKg22H2n85rT/s/h81bIaHNCMjMgyDs3FUS1DSIEXbmuq9px/ip7wp2nH+K nvCuVfs/h81P2fw+apf+eOs/0/xXPyT0+K6r2nH+KnvCnacf4qe8K5V+z+HzU/Z/D5qf+eOs /wBP8U/JPT4rqvacf4qe8KuKysAykEHcRtFcm/Z/D5qm/JWZ12nSYpYE4sllsb2RxxAeW9VX 6T04ZxLMxxwZTruzyykMpHSlKyK5KUpREpSlESlKURKUpREpSlESlKURKUpREpSlESlKURKU pREpSlEStZrpPVYajarZuMH8HWA/SBWzrX67G76VO0QvLBw5CAby0DLNbx8NqItfkgHJxwfj 5rW/EI3C/wANaLGdOyYbQZPFPxN+zHwvwIqAmVlHtMpNkv0kA7K3uaxEX+QhUvFjyx6hEwB9 eGReGYDvhbmrOrS6JkTw42BwnV4iJcY44RSjbHtIzlU4W2XUm/SBRFrMrFWPClfE6+LJICbJ mnLzF1tGTKD6zSKPXQAX3GrogzYc7HjgjWXrV+1I0aMYAydWird4+Aybj3ySSaudfkxwYw1D EEuXExnzVgt1oSMtJfhdgxCFrKVJvf1e5WbkZWmx5Wm6p13/AK0qSlsiTZuEfCG2bGFiLHuU Ra/Iw9VWZxNjQCXJaRoU6xiUeYIjNYLt2LY+GkYlhzcXFyhHFkY8mHFHGjcTPFxvtctbiKle ju1madq2KMzJzdQusztbHsjHgitbh2X2i209/ZVBn43aNU1GILOQkMeK4FyZnMqqin71yLgb R00Re8UL/hlB2A4uan6Fc2rA5imePTdGKysjND63C5W46uPfYithlY8mHpr4igiTqI9PhJ3S TZJ/cZd17Xv5a3vYsUxxxvEkixKFTjUNYAW2X8FWUzELBMh2fBRnHNExBZ1zhMqb5h/7jf1V fTJl+O/9xv6qn/YMH5aL3F9FV7DhfLxe4vorUdZA/Qe9UiiXUoMmRL8d/wC43pq+k8nxm98+ mpl2PD+BH7i+iq9kxfgx+4voqB1UT9C6KT1KJpPJ8VvfPpq+kz/Eb3j6ak3Zcb4Ke6PRTs+P 8JPdFROoifpUvSPFR9JX+I3vH01fSRvvn3jW66iD4a+6Kr1MX3F8gqBtHBdyHitWjt94+U1f Rj94+Ws3q4/uL5BVeBPujyVEzB3KWXmrCE92ryV64V7gpUCV1lZbDw2Ys0EbMxuWKKST39lU 7DhfLxe4voqEcxnMxNZnQTyrHLaWMB2AswsbAHoYGtZ2zM+Zl/uP/VW2GklKMZCzCQB2KiV4 BIMdhXSuw4Xy8XuL6Kdhwvl4vcX0VzXtmZ8zL/cf+qnbMz5mX+4/9Vd/Cn/k8Fz8iPQuldhw vl4vcX0U7DhfLxe4vormvbMz5mX+4/8AVTtmZ8zL/cf+qn4U/wDJ4J+RHoXSuw4Xy8XuL6Ku RY8EN+pjSPi38Chb28Fcx7ZmfMy/3H/qqX8mJkNhz5U0jyCWThj42LerGLG3Ee6aru00q4GR m+5lOu0SkwiykdKUrIrkpSlESlKURKUpREpSlESlKURKUpREpSlESlKURKUpREpSlESlKURK pVaURRmaLIwsiPTDJ1eFEXyMQFiiugswiYrdmEJv+2PaW3QCK1zpiNo0uEccDEkyFlBA9aGX ruFxMo4uFW4SVPQvqta1zL83CgzoDBODYEPG6nheN12q6N0MtRrNwsvBRxL+3wo642fCtoUe W5kmlRFZklf2S+1LXtw3tRFsexCTFRcWdex5KAFWa7wr7R6iTaSpItwnd0HorQ6jp8KS5OZ1 sYwcyeJE4VedhJJ/zCOJXCleK53E3vsq9Di4s2RHIuHEjZcxQyY4UwKvC3VcYKyoWdlvsAsp F9teRHEmPj5RgjZcmKWWJI8fHuBGUG8RX3PxbBewoi8wSPEwdo5smHbxSzNLB1RS3DdiUjcO N3TfZYirsONDHkIkAnxp0gefDSRnnRJD7WTJHK5C8TXUBQSL3axIFXhHp2l5sc0sUMkM0fDJ lBj1ysSwVoQSLiwsRGvECbi9X8LRp8sIshmh0+Ni0TTse1OCOBlT7UKuPa+0dtgt6Iq4eTNN xatqcofDwAxQqvCj5AHVuyLxNfg2pcGzMSR0VoX1vVppXl7VLGJGLCNWsqA7lHgqb5Wk4GXj xYs0V8eG3VxKSiDhFl2IRuG6sUcr6GN2N/G/9VaaLaawc8TKR5AgBVWQnIjKQAOaiq6rqh// AHJveq6up6n83L71SYctaKN2P/G/9Vehy7o4/wCj+N/6qtOpo6D/AEhQ9Kzq8So4upaj81L7 1Xl1DP8AmZPerfjQNKG6D+Jv6qqND0wbof4m9NRN9PT/AMQu+nPj4rSLnZ3zEnlq8uZmfHfy 1txo2nDdF/E3pr0NJwBui/ib01A3V9PgFLJPj4rVrl5Xxn8tXVycj4reWtgNNwhuj859Nehg Yg3J5z6aibIcPBdyy4rDWef4jeWrqyy/fPlrJGHjjcnnNehjQjcvnNQM48FLKVZV3+8auqzd 2vQhjG4V6CKNwqJIXWWPlabgZrK+XjpMyAhS4uQD0VY/1/RPkofdFbCtVrONrbDr9JyuBgPW xmVCGt0ozDYfDsqUJSJERZkHMkBckAz5c3sxV3/X9E+Sh90U/wBf0T5KH3RUPm5h5igkMU+Q 0Uo3o8SKfOtef9m175v+BP6a1fi6j/KP6pKn1qujwCmX+v6J8lD7op/r+ifJQ+6Khh5m10b8 v+BP6ay9P1LmzUnC4kxZL2aZo0ES+FuHb4BQ6e+Ic2gAbzKSC2slhAn2BSj/AF/RPkofdFZs EEONEsECCOJBZUUWAq3hQZEGOqZM5yZt7ykBbk9Cqu4VkVjlKRwMjMDmW8VeABiAyUpSorqU pSiJSlKIlKVjT6hgY0giyMiKGQjiCO6qbd2xNdAJwAfsQkDasmlYq6pprCMrlQkSsUjIdfXY EAhdu07auHLxRkDFMydoI4hDxDjt3eHfTLLge5cccVepVKrXF1KUpREqlVrxNIIYXlb2Y1LH wKL0Re6Vy/8AyOoP6/aphxEtbrG6dvdqWcmHIlxsnInleUNII06xi1uBbm3Ee61ardIa4GZk C25lTC4SllAUkpStfr2S2Lo+XMhKuIyqEGxDP6ot5azRiZSER9RA71aSwJ4YrYUrl4z88bO1 z/3X9NTjlfrf8LFNPI0jSl5OKRixAJsNrd4Vou0pqjmMgXLMyrruEyzNg63FUrmmRqedLkTS rkzKskjsqiRgApY2AF+5XmPVNQhlSYZMzGJg/C0jENwm9iCemrPwJN847lD8kcCunUq3BMk8 Mc8Zukqh1PeYXFeyQASdgG81ibctCrVK5nNqefLPLKMmZRI7sFEjAAFjYAA9ypVyYciXDyMi eV5eOXgTrGLWCKL24u+a1W6U1wzmQOzBlTC4SllAW0m0TS5pDK2OqSm95IiYnN992iKmvA0H BBHrZBA3DtE1h4LPsqH63qWY+r5fVZEqRpJ1aqjsq+oAu4Hu1m8oy5mTqrGXIlkjhiZiruzK SxCjYT4aS0hjX6hkPlzM3ggvBnlA3spVi6Xp2G3HjY6RyHfJa77fxtdvPWXWk5tzXxdJKxOU lndY1ZSQwHtNYjvLUK7fn/Nz/wB1/TXKdLKyGbMI4tsXbLhAszrp9VqAcv5+YdaxFlyJXR2Z SrOzKbq3QTU/qu+k1SESczh1KuwTBLMxZKpXieaPHhknlPDHEpdz3Aoua5xlavqGVky5HaJY xKxZY1dlVV+yoAPQKlRp5WuxyiO9cstEGwd10ulcvOoZ4BPap9n/AMr+muhaKsi6TiCVmeQx KzMxJYlhxbSfDXb9MaogmQk5bYuV25yQzMs6lKsZmVFh4suVMbRwqWbxdHjqgAksN6tV6q1z KXVNRmleZsmVWkYsUWRgq3PsgA9FW2z9Q4TbLnvY/wDa/praNBLrHcs/5I6Suo1SsfTpTNp+ NMTcyRIxJ27SovUA1DU8yXUMqSPJlWNpX4FWRgAqnhFgD3qop05slKL5cisnaIAFnzLpFK5f 2/P+bn/uv6advz/m5/7r+mr/AMCXWO5V/kjpK6hSuX9vz/m5/wC6/podQzwCe1T7Nv8Ayv6a fgS6x3J+SOkrpWRiY2UnV5MSTJ3HUN9Na1+VdCc37Nwfld1Hk4q12rz5OFythx9c4yJuqVpO I8e0dY3rb6i7ahqAUntU+wfFf01ynT2GJMLTAZjHB8W3pZZAECUM2DqfQct6JAwZMRGYbi93 /nJrZKqqoVQFUbABsArG0yN4tOxkkYvIIk42YksWIubk9+veXmY2FA2RlSCOJd7HpPcA6TWW RnKTGUpl2G9XARAcARV6lQvUeccyYlNPQY0XRI4DSnxeyvnrRz5ubkm+RkSyk/edreQG1aIa Gwh5EQ5bSqpaiI2DMun8a3tcX8NVrlNvD5TWz0KfUn1LGxsbJlRXcGReIsvAvrP6rXG4VKeh yxJFgwD4hlyOocgZdvNdDqtUpWJaEqtQzmzWJjnLhYsrRpji8rRsVJkb7JKn7I+mtF2/P+bn /uv6a116KU4CRkI5sWZUSvEZEM7LqFR/nGGD/FNO0adaJIlEhA4gpcbOLfasTkvMnmly4Z5X lsEdeNi1vaU24qlLxpIvDIodd9mFxs8NVEGi4P5shBwwfepgiyHDMopzDhQvnRY2OixGHDny YUQBQJVZWBsO7w1bwpev1nTtXf1W1GWfgB3iJI1jjHmNS8xxl+MqC4HCGsL27l6p1UXqngW6 exsHq+DuVIahoCJD+WUXfqd/ghqxd94PcvVVpSs6sSlKURK1fMk/UaJlsDZnTq18Mh4PrraV G+d5+HT4Mcb5pgT4IwW+m1W0RzWwH3DwxULC0JHkoZYDZ0VP+VYOp0PHO4y8Up/Wxt5q5+wJ BA3nYPCdldRw4Bj4kEAFuqjVLflAFbdfJoRj1Sfu/mqNMPMTwHvV+o7zrPwaZHCN80yjxIC5 +gVIqhvO8/FmYuOD/wAcbSEd9zwj+Wsmli90eXm7ldcWrPPBRlr8Jtvtsrok5Gm8usNxx8Xh H5uDhHnqB4EHac/Fx7XEkyA+C9z5hUz5xn6rRjGDtnkSO3evxn+Wtmq81lNfGTlUU4RnLkoI BwqAegV6ZWRijgqy7Cp3iqBS5CDe5Cj9R4frrbcz4nZdYkAFkmRJF79hwN51rSZATEeoE9zK kDyk8CB3qRcnZnX6Wcdjd8Rin6G9ZPR4q2WsZHZtKy5ulYnt4SLDzmofylmdm1dYmNo8pTGf zr6yfWK3/OM/VaOYwbGeREt3QDxn+WvOtqbVAbpyEu/atUJ/ok9II/coKo4VAPQK6By5GuJo EEjC10ad/wBRL/RUAILeqN7eqPCdldB1huwcuzopsY4BCtu6QI9nlrRrMRXX1z/b3qujDNLp iuftIZXaVt8jM5/UeL66lnI8FosvJI9p1jU/kHEf5qiQFtg6Kn3KcHU6JC3TMWlP6m2eYVLW SakjqIHxXKA9j8A603O2Tx5mNiA7IkMjeFzwjzLUdSJnimlHswhC3624BWZruT2rWMuW91D9 Wp70Y4PpvV/Exz/rWo5NvamiUHvRlSfO9Sr/AE6axxyj2yOKjLzTke3wWLo78Gr4Lbv30Hve r9ddKrluM/V5UEn3JY28jiuoSyxwxPNIeGONSzsegKLms2vHmgeIIV2mOEu1RrnTUuCGPTYz 6037k1vhqfVX9TfRUUjhZ4pptyQhbnutIeFV+k17z8187LmzZdnWtcA/ZQbFXxCs/PxTg6Hh QuLTZkpyZR0gKvDGviDeWtNcfShCH1SOPbtkqpnPKUtwH8lqCOIcI+16vl2V1SGMRQxxDcih R4hauaafF12o4kPQ80YPg4gT9FdPrPrzjAdpVmmHzHsVKifOmpXMemRndaWe38C/X5Kk+Vkx YmNLkzG0cSl2PeArmeTky5eTLlTf8kzF2HcvuXxDZVeiqzTznZDZ2qWom0co2y9yyNJwe3ZT RsCYoopJZLdxVPCPG1qwVN1BPSBeprynpvVaXJkSC0maDbuiICyeXfUKAsOHubPJsrdXZnss A2Qyj3uqJQyxiepyuhctP1ug4m2xCFCRvHCStYn+k6V8XI98f0165Mk4tHK/DmkXy2b6639e bZOddtghIxeZ2LVGMZQjmD+VQvmDl7TtKwO0QvK0rSLGgdgV9badgUdAqNk2BPc21LOeJ9mH jDuvKw8A4R9NRaKIzSxwjfK6oP1ELXoaaUjUJTJJLlzwWW0ATIiGZSzB5P0+fCgmneYTSxq7 hWAALC+wcNX/APSdJP8A2T++P6akCqEUIuwKAB4BXqvOOpuckTkFqFUG+UKH87SgSYWIuxUV pLeRF+uo7iwnIy4Mcb5ZUTxFhfzVsua5+u1uUA3EKJGPDbjPnavPLEHX65j3FxEHlP6RYedq 9Cr9PTA8IGXfis0/NaR9zKfTzRY0DzzMEiiUs7HoArnWr6tPquUZ5LrEtxBD0IvdP4j0nxVI udc4pjw4CGxnPWS/kTcPG30VDybC++q9FSBH1CMZfLyCnqJl8g2DasjBwMrUMgY2KnFIdrMd iov3mPcqW4fJmnxKDmO+TJ0gExx+JV2+es7l/S103TkRh/7EoEk7dPER7PgXdW0qi/VzMjGs 5YjBxtKnXTEAGQclag8q6CRbsgHfDOD/ADVXTuXMHTcxsvGLkshQI54gtzclTv6K21Ko9awg gzkQdrl1bkg75RhySsTU86PTsGbLfb1a+ov3nOxV8ZrKqGc5al12Umnxm8ePZ5bdMjD1R+lf prtFXqWCO7bLsXLJ5Yk9yjskjuzyynjkcl3PSzMbmszVMHsE0EBBEjY8ckt/iMW4vJuq9y7p /b9ViRheGD96XuWU+qvjas7nVLapA/Q8Fvdc+mvTNg9aNY6ST8FkEf0zM8QF45Mk4dXkTokg PlVlP11Oa57yxJ1eu4xO5+NPeU+iuhVi1wa0HjELRpz5OwpSlKyK5KUpREpSlESoVztPx6hj 44OyKIuR33a30LU1rn/NTE67kX+yI1Hg4A3/AJVq0Qe5+mJPwVOoPk7SsHTIO0aniQEXDzJx D8KniP0V02oByqobXce/QshHh4bfXXQKlrz+pEcIv3lc0w8pPNUrnvM0/X65kkG4i4Yh+kXP nNT+aaOCF5pTwxxqXc9wKLmuXzzNkTy5De1M7SH9RvXdBHzSlwDd65qTgBxLra8qQddrcTEX EKPIfDbgH81bHnie74eMDu45WHkRfrr1yPin/wBrNI2ErCh/L67fSK1vNk/Xa3Iu8QRpGPCf XP8ANV3z6z/rh+3vUPlo/wBclhaPD1+rYcW8GZWPgT1/qqR874nFj4+ao2xP1Tn8Mm7yMK1n J8HW6z1nRBEzeNyEH11MNUwxnafkYh3yoQp7jDap8tQ1FuXU1ndAY/7tvgpVQeqX3fBc1imb HljyE2PC6yL4VN6k3OmUk0Wnqh9WQNNbvFQFP8VRfbuYWI2MO+NhFZmdk9oxtOUm7QY7Rt3i rkD+ECtM4PZXPpzDvCpjJoSjxZNIg7RquHFa4Mqsw7yeufoqUc6z8GmxQDfNMPIgLH6q0/J8 HW6z1nRBEzeNyEH11kc7z8WbjY4OyONnI77nh/8AGqbPNqq49EcysjhTI9RZRpr8Jtv6PDXS gV0zRgTsGJjjyonprn2nQdp1DFg3iSZA35QeI+YVMucMnqdHMQPrZLrHb8I9dvMtc1Qz2VV8 ZOexKfLGcuAUFuSOJt59Zj3ztNS0Ypi5HdbWaSPr2/U4f6KiaRtNIkK+1Kyovhc8P110bU8d RomTjoPVTHdVHeVNn0VLVTY1D/6CXcuUxcTP2t3rnBPD6w+yQfIb1MucNS4MCLCQ2fLs0lui Jdp8psKhe1o9m8j6qztWze25rTBrxIiRxE/cRdp8bXNW2V5rKydkMx9uDKEZtGQ6mC96Hpx1 LU4oCLwp+7P+RTu/UdlbHnSUNqkMI3RQ3I77sfqWt1ynppw9O7RItp8u0hvvVPsL5NvjqMcy TddrmUehCsY/Qo9NUwn6mpLfLVEgduwqyUctI4zIVeWohLrmKDuTjk91Tbzmuh1B+S4+LVZZ OiOA+V2HoqZ5E8WNBJkTHhjiUu57wF6z60vcAN0QO9W6fCD81GedNSssWmRna1pZ7fdB9RfG dviqN6fhnPzYcQGyyN+427hjG1z5K85eVJm5UuXL7czFrfdH2V8Q2Vjlk3EjwXrdVVkqEBhJ sT9xWac808x2fBdUR8eNFjRlCKAqqCNgGwCuY5KdXlTx7+CWRb+BjVi8XdHlr2LW2buio0af 0jI5s2bkylZbnbBmUu5GkJgzIuhZFYfqW3/jUpqGckSWzsqLoaJWt+VrfXUzrBqw18ubHwWi gvWPaoHzfP1utMnRBEieNrufprG5dg6/W8RehGMp/QCfprH1SftGp5c17hpnCn8KngH0VuOS oOPUZ5yNkUQUHvu3oWt0v09N2Vt7Ss481vbJTSlVrG1KcY2n5ORe3VxOwPfANq8oByAN+C2k sHXOM6ftGdk5HxZXYeC9h5hW+5Ig4svKyehEWMeFzxH+Woyt+EX3221N+SoODS5JiNs8zG/4 UAQfQa9XVHLQQN7RCxUh7Ae0rR83yF9bZSdkUSKPHxN9da3T4hNqOJC21ZJ41Yd7iBrZc3Rl NbdjulijYeK6fVWpxp+zZUGTv6iRJCO8pufNUqv7EW/x4drLk/7hfqXU6V5jdJEWRDxI4DKw 3EHaDXqvHW5KUqlEWNqObHgYU2XJuiUkL95tyr4zXNJJZJZHmmN5JGLyN+Jjc1I+c9S63Ij0 6M+pDaSa3S5HqL4htqMkgbSbeGvU0dWWvMds8fZuWO+byYbI+9TnlPDjwtO6+VlWfLIkYEi4 T7C+Tb4613O4RpcOVSGuJENjf7rVFbxHpHlqqlPskeKpR05F3qmbnHBuOC4bXhkyt7VmaVJ1 Wq4UnQJ0B8DHh+uum1ylHMbpINhRlYH8pBrqqkMAw3EXFZ9eMYHkR3K3THCQ7FWlKVhWhKUp REpSlESoLzhjPDqwnt6mTGpB/FH6rDyWqdVharpWPquKcea6kHiilHtI/dH1irtPaK7BI7Dg VXbDPFht2hc7w8ubCyosuD/kia4B3MNxU94iplDzlpDxhpRJDJb1kKFrHvMtwajWby7rGG5B gM6DdLAOMEd9faFYHZcq/D2eXi3W6t7/AEV6M66bmkS7b4lZoysrcN3hbrX+ZTqUfZMVWixC byM2x5LdFhuX6a0cccksixRKXlkIVEG9mO4VnYug6xlMBHiugP25v21HvbfNUt0LlyDS/wB+ VhPmEW6y1lQHeEH11GVtNEMsGJ3RBfHmuiE7JPLv/cs7ScBdO0+HEG1kF5GH2nbax8tc81Cf tOoZU/RJM5XwA8I8wrpOU8iY0zxKXkVGKKu8sBsArnS6JrVhfBmv0+qN/lqnRyGayc5AGTbS 3Mqd4LRjEFgpByPB6mZkkb2WJT+UcR/mqV1qOV8KXC0hEnQxyyO8jowsVLGwv4hW3rNqJZrp kY4t3YK6oNCI5LnnMmF2PWJ1AtHP++n6/a/iBrV1NubtLnzMeCfFiMs8LcJRRdij7/IQKi3+ F1n5Gb3R6a9DT3RlVHNIAgMXPBZbayJlgW2qQcjwft5mSR7TLEp/KOI/zVpeZZ+v1vJI3RlY h+gbfOalvLGHLhaQiToY5nZ5HRh6wJOy/iFRDI0rWp8mac4M15ZHf2R9pie7VVUonUWzMhh5 Q5/bgpzBFUIgHiVkcpQddrcbEXEEbyHwmyD+asvnbJ483HxQdkUZkb8znhHmWsvk/TMvFlyp 8uF4GYJHGHFiRtZreatVrWn6vmarlZC4czRl+GNguwog4QRt6d9dEoy1RkZRauDAvvP81xiK WYvKSsctY3adbxgfZi4pm/QNn8RFT/IXjx5U+8jDyio3yhpeXiz5OTlwtAxVY4w4sSL8TEea pRWfV2CVuBcQAGHeraItDHeuUKLKB3BathoenHUtSixyLwp+5P8AkU+z+o7KyX5U1zjfhgQr xNwnrF3Em1SblnR5NMxHOQAMudryAHi4VXYi389a79TCNZMJRMjgGPHeqa6pGQzAgDa63AAA sNgFcvzZevzcmbf1k0jDwcRtXTchnWCVowWcIxVRvJA2AVzhdF1qwvgzX6fVG/y1RoTEZySB sGJVmoBOUAE7Vv8AkaLZmzW6Y4wfACx+mvXOmpcMcemRn1pLSz2+4D6q+NtvirM5VxMjB0uU 5MTxyvK7mMj17AADZ37VGs3A13Oy5suXBm4pm4gLeyu5V39AqURGeqnOUo5YMznadi4XjTGI BeS1sccksiQxDillYIg7rMbCuj4ekYOLiRY/UxuY1Cl2QEsekkkdJqOcr6HlpqBy86BoVx1/ aEgtxSNsuPyipjUNZc8hCJwjiW4lSorYGRG3isfsOD8vF7i+ioBr0Sw6zlxqoVeMFVAsAGVT sro9QnmTStRn1mabHxZJYnWOzoLi4Wx6e9UdFNrDmlhk3nml8XiGG/crHKMnBraL8SKRfJZv qqb5cwx8Wac/9UbP7oJqE6HpurYur4s0mJLHGrEO5XYFZSpvtqU8xLkSaPkRYsbSzSgIFQXN mIDeau6oRlfBiCJCIJfmlLiuWBwdc6UkgE7ztPhO2pnyRDw4GROf+2aw8EYA+kmo1/hdY+Rm 90empxy9iPh6PjQyoUl4S0ineGcljfy1frLI+k0SDmkNhVdETncghgtlWk5un6rRJVG+Z0i8 pufMK3dRvnDHzsuPFgxIJJ1VmkkKC4FhwrfymsOnAN0HIABfHlitFr5JNwZQwmwJ7m2uj6DA cfRsOI7+qVj4X9c/TUGXQtYdlQ4UqhiFLECwBNiTtro6IqIqLsVQAPAK1a6wGMIgg4kli+xU 6eJBkSG3KPc46Y+RipnQrxSYt+sA3mJt5/SdvlqF98V1bfsNRbV+TxI7ZGlssZYktjPsS/4G Hs+Dd4K5pdTGMfTmWb5T8F26ok5o+0LWaLzNkaZGMaZDkYg9gA2ePvLfYR3q3685aMRcmVT3 DGb+a9RGfSNVxyRLhzC32lXjXyperK4uWxsuPKx7gjf0VfPT0WHNx2mJVUbbIhveFLpedcDi VMeCWQsyrxPaNRxG19pJ81bvPzI8HDmy5fZiUtbun7K+M1AINB1nJIEeHIvSGl/bXZ+bbUg5 rTVcsQYWNjSSxKBLM6C6l9yqDs3b/JWeyinPXGEg2OfzbgrY2TyyMgftwUTllknleeY3llYu 5/E22pPydpUckc2fkRh1c9VCrgEWX22se6dnirRroWsu6oMOVOMheNgAFubcR27hXQsPFjw8 WLFi/wCOFQg79unx1bq7gKxCBHm6TsAUaIEyzSGzjxVOw4Py8XuL6K0HOWJjxabDJDEkZE6g lFC7GVt9qk9afmnFny9JaPHjaWUSIwRdpIB21jomRbAk4Zt5V9kXhJhuXP32qfAa6VDmcGjR 5vCX4ccS8I3mycVqgf8AhNZ+Rm90empjgy52Dy7jnsbzZUSBDjbFewbh6fw7a16zLIQYxl52 bMN6oocGTgjy8Fi6Ln6xqITUHzMYYl2M+KiXeNQDYcW+9ZcXNWiyvEizMOuPCCUYKpJsAxtY XrRPDPDPm6xFhPpmImNIrxuQOslkHCtkG4XN6pi4OZm6fp+mJhyQY0DDIyslwB1n2v2rXJLA 7KhKqokyLCOzy5RlwJL8SMFMTmMBieb4rccxaxmYjLi6cV7SI3yZmYcQSGMdzvmtrp2QcrAx slvamiR26NrKCajiaPqWoJqGp5DTYmRkcax4oC3eJR6kb3B396t1y9HPFouLFkxtFMiFWRth FmIHmqq2MI1ARMTKMmk23EYqUDIzLuxGC2VKUrMrUpSlEVKrSlEVKrSlEVKrSlEVKrSlESlK URUqtKURUqtKURKUpREpSlESlKURUqtKURKUpREqlKURVpSlESlKURKUpRFSlKURVpSlESlK URUqtKURKUpREpSlESlKURaTnD/+Bkb96bvzDf3q2uH/APiQbv8AjTdu9kUpVx/sR/7Je4KA /uH/AEj4q9SlKpU0pSlEX//Z --------------1553ED15CC70BAB9B8EB79B2-- From leroy_tennison@prodigy.net Wed Jun 16 19:21:40 2021 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ltb7R-0001mw-UU for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jun 2021 19:22:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ltb6v-0006WW-4y for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jun 2021 19:22:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ltb6u-0006Vb-D0 for pgsql-admin@lists.postgresql.org; Wed, 16 Jun 2021 19:22:00 +0000 Received: from sonic302-25.consmr.mail.ne1.yahoo.com ([66.163.186.151]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ltb6r-0002sQ-MO for pgsql-admin@postgresql.org; Wed, 16 Jun 2021 19:21:58 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=prodigy.net; s=s2048; t=1623871316; bh=Ozj36V/OxcrYcnW6mcn3aAMH4FEleV+JQ6qvEwjS01A=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=QCj2AybQwZCK17ipjrxxRMPI25CrJkdfL5Tn7KrIxYeHYpohXQ9c60AeHh0osCjzByQw55yBjJZjFUIEfaUW7XnAhlgWnQ/PILjLuziBsxbGikAqdVZEFOKqjclBzIj0GuO0UGBO2FO/nkT5Hg6iFBVWGb9TSjgs+kJBh8NIbmE0jg8o3+22tSEm9jXic/dCdlF7Sx7/ejvusrrtLlMS0un5LWIVQnL8zPdQPE//1J/xoujwqyz9hd34iskGz51/da8tkwphSw9ymFhGTNex2kLP3UcUoY0PgMtcvIBUxR4EVqZVyEhlSlrrY7y3mbJzxMo7yuSqfHwbHwPdnDD18w== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1623871316; bh=t2RqqtsXS2dg76HMwolQq6XgLC4Vp96k0PcluZg1OZf=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=Nk4VkiFj3rxc9d/NKqHjq6LDHJVxAYq3rqpYgOxng7SPRBZVW+TkK7ORVUVAPMQj8i64Nb0jpnGMnNmT75Q1BxGHw//yiZczhrh7eOH9t0Pa/QqehG3nuvctqqwbOq1pBVqJOJf1EYkailiWYST/6NIvHihFJfPhjsCKVpckPiGv9NM4Me4A02cLJYpNPbZm7L9R/ia00Kf06mvZvDnOs1wGpn/iawj1F1PguE8BoOJAEaj9qab2Snn1FX0IYY5sbxHxglON0zsp/M1b+5DZ/rcTC6eRqylqDWC5PWHuMErJa7v1Tv5e2uHoHsK105tptU9y71Xvjbc5zaHhokMo3w== X-YMail-OSG: uAZgHYIVM1lVFLhLFIVGiz7FcjwFY7BDAL_ir1.TkWuzj2kfwVDRj8d1hFRUlT2 I9V84.G0sVxAnlfdz6VcOVU2zCtftXeBbBcXfwd97lhx.ugSxPTuNmARAz4waQQh_D0lQooo6SrW Za1C_kwSmbDLlqK3R0voHJieg7oOglvpOcwDKEsRp2zxGQc1uCgbfRRnlqwH0GbqK4xzlVPSMBQY P8zZU1L2LI9mrhJBwE4L2KOHddWKejxEpZavxCRUIaK6b4B0j0wveNfrS0yGlS14KUsJTeA5X49y I5q0jq23h9MvTRmT3vE70yPKqvYL5FldAa3F3QCzy_NLIWN0fOWqlRaH0QkmCxPUgfdq_p9lPRNW 9HR21fqMaKtTrfwvsW1JLDkp4K_GTu5JI2kcCSOZhWbqPF_J4xD9vEHQQ_NlpVATOFdk680FhcC. lOUWl6qTWPxlVr7j8ly0BBunYAXfFQmuplxBVU2jjbp4jKhCsN51PbLjqOageGfWjmKwdJwFq0aL 6Eypqt_MWDLgmc41eYROsjqmYKSWlKkX5Vd0z8y_uJO_Vdlz6S82xGzq7en6StjVyQBvBLlnfx0b 7rn5Sqisl1BhjMmiAlQHSI5PUvHhMYrD3NcAW5PylIf9Jc5MkinnkuAZ_dKRWZfYc8mGnsLH9uIA d.JbJvJmAcRoYB3WmfCDfPKM9t6Cmxl6mIafxykxeJnr7b52aTct1A2eYxE8trFw6rjjVMhK3MT8 0R5i6uPjspiKn14Wvm2tEbtxjcs55BYifFesaHxd7WgsI5yE1VLw1aEziZm0XbCGMP07AX5J9Qwy RdOVe6NvxDA3WcCRH5XtZIheWMcOVr4ftqXFMh53hY5aLvK3fgsaE8cLLmy8V6vrX_7jeNKtEcLv BViJSEwMX6J0URW9TSsvJgbhA.LWovCMaviTw_y2S0zK4giVSBYxBX2C5nQiGqSwfwXFxp_vWxKW RIMY2oKituxMCOD0Nya4DX_SivxaP3mYBXEyfqnjfIkwNwvT8YCIx1z5dgs10AOXtxsUkFaswaR_ Y0ao2X6CrPVSBKWlVxzxPOoaI9LMzjLPO4sjh1NiMHPX.Gr67w.8AILz1psHjRraxiPIpal9Joqd HEv8w88vslwWY2sPYHowRVBXybrh2VYTZDq3AggfmA0DlZSeNfd9cqCV9osDSvS1GcPgmU859U2n zmDR_9ViGhJ0uf1EhpnBdD7CP2fHO0ysokkgrux2Dbkc8u6yFzSke913kVQgkTlB3q3VGYwBdWXB K4gAEuidWsuUiPI3M2YNNqQ_102k_KBxYACSDVSLp3XQsu2tzd_ZBhyJfpR3ia49D1u636mG9dpJ 00SgOHfTpXX3u52ULx.7RDUEBGCmAuRBd3zrNUFIQZi84XwtsPROW6E6wNlfNLr.PywG3Ta5acRW HDil7ZGPIJdiYwC4FVG1WeGBmAziZz2NLOicqYd.pf.s5zs24JOxCNxslIVec7KKFTNBp_laxdzX 8zugeRLEzEYwZPQUPPflwBN0HqfSBakoIQ23j5JZ0xEmh9IwryBJSsFPjnfO2KZvdU35_OgE2XUZ gt9w9fqKYxfQSebyNfzsXUULMfBW2XRqBp.aMnr_b.YuIH_e5DAfs0._FO3FXGvnCqO0hKKXnJ6y 3UzhjfXxup9XvQkXdBnq7iJwqkq_DJhrglVuhohNMAN5bHOTm33ZztYvfj9_zWAXK3_kBSrIQ.Da g.g0NC9Km2nqNkpyyvt063Qh.WWrI.EQFlTx_UWN.EOvArh1Qtm6AHUMkWhadvSpqtPQaX4FUw9T .GSz62nk6IjW40RmM1qGhVshsz_Qkejf3n7x18ldA.7Rm.jtA.PdSS3rn.6Su4f5vtC5XtKfQlZW _QK3lbH.HOMX7dOp.XdTE8Q6SeM0UZKi6pkC4Cyy99yCjOQiAp6LCMnURbPgwvq7h0ZGLHN7DOf3 ZbQphk8ddt_0XMpAEye7xPcvVYEbGdHFI6viqJTcvmGBp3gIsAszMf_82Q0FzvDnja6.HOE8Ykq8 rRYdxJvnN67E6Y9xawjVSGqsGjNxBAFGZazMdc9mhM_4JV4j21mGKyJi8PaVHwsgVJS5.vGWjEqA PHNko6yS3jopwCpMXv3_QuOvrd7z8GIfqh7LxGWuHcjyInvORPd.rppnykxQwDXqsIWwOHx.qTW1 r1jB7ZwoDuWd7gYIfpgmh6qzCnWomxQq3VOFuP6mXCVsC0mDsMvqo6vdtsTl9uNdOiAwHqBHZJdG SZTdrgx.JpLJgiLPaNd8HocdQGWC0FllQ5wmxviv2xGWX17ox3O9UfEZXvOd9Yg2HIhR8s2un3LA MrVfiDlyJgYdd94Y9ombuzRBeuL7p1rSF9DrCkgpbIzSzPHhJXtcJbYbpi8wXJ1QH4H0IocxmT0n qdlZpbaGbMT7uIVnELpgVE5k54MPvVg-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic302.consmr.mail.ne1.yahoo.com with HTTP; Wed, 16 Jun 2021 19:21:56 +0000 Date: Wed, 16 Jun 2021 19:21:40 +0000 (UTC) From: LEROY TENNISON To: pgsql-admin Message-ID: <192101066.1663055.1623871300493@mail.yahoo.com> In-Reply-To: References: <1ltQeA-000URA-EE@unimaticaspa.it>

Subject: Re: compression in replication MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1663054_427641003.1623871300492" X-Mailer: WebService/1.1.18469 YMailNorrin Content-Length: 3603 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1663054_427641003.1623871300492 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Keep in mind that this can be accomplished in other ways depending on what= archive_command you're using.=C2=A0 rsync, and sftp (I don't recommend scp= due to security concerns but it does compression as well) both have parame= ters to do in-transit compression.=C2=A0 If i remember correctly Postgresql= compression must be enabled on both ends.=C2=A0 I had a situation where th= at wasn't easy to do and opted for external (to Postgresql) compression. On Wednesday, June 16, 2021, 2:56:09 PM UTC, Vijaykumar Jain wrote: =20 =20 sorry, the link was broken. this was the param. "wal_compression (boolean) When this parameter is on, the PostgreSQL server compresses a full page image written to WAL when full_page_writes is on or during a base backup. A compressed page image will be decompressed during WAL replay. The default value is off. Only superusers can change this setting. Turning this parameter on can reduce the WAL volume without increasing the risk of unrecoverable data corruption, but at the cost of some extra CPU spent on the compression during WAL logging and on the decompression during WAL replay." =20 ------=_Part_1663054_427641003.1623871300492 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit

Keep in mind that this can be accomplished in other ways depending on what archive_command you're using. rsync, and sftp (I don't recommend scp due to security concerns but it does compression as well) both have parameters to do in-transit compression. If i remember correctly Postgresql compression must be enabled on both ends. I had a situation where that wasn't easy to do and opted for external (to Postgresql) compression.

On Wednesday, June 16, 2021, 2:56:09 PM UTC, Vijaykumar Jain <vijaykumarjain.github@gmail.com> wrote:

sorry, the link was broken.
this was the param.

"wal_compression (boolean)

When this parameter is on, the PostgreSQL server compresses a full
page image written to WAL when full_page_writes is on or during a base
backup. A compressed page image will be decompressed during WAL
replay. The default value is off. Only superusers can change this
setting.

Turning this parameter on can reduce the WAL volume without increasing
the risk of unrecoverable data corruption, but at the cost of some
extra CPU spent on the compression during WAL logging and on the
decompression during WAL replay."

------=_Part_1663054_427641003.1623871300492-- From sfrost@snowman.net Thu Jun 17 16:30:48 2021 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ltuut-0002Ou-A9 for pgsql-admin@arkaria.postgresql.org; Thu, 17 Jun 2021 16:30:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ltuus-0007GJ-8i for pgsql-admin@arkaria.postgresql.org; Thu, 17 Jun 2021 16:30:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ltuur-0007GA-Vl for pgsql-admin@lists.postgresql.org; Thu, 17 Jun 2021 16:30:53 +0000 Received: from tamriel.snowman.net ([70.109.60.50]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ltuup-0004ls-Sm for pgsql-admin@postgresql.org; Thu, 17 Jun 2021 16:30:52 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 2A03E5F799; Thu, 17 Jun 2021 12:30:48 -0400 (EDT) Date: Thu, 17 Jun 2021 12:30:48 -0400 From: Stephen Frost To: LEROY TENNISON Cc: pgsql-admin Subject: Re: compression in replication Message-ID: <20210617163047.GM20766@tamriel.snowman.net> References: <1ltQeA-000URA-EE@unimaticaspa.it>

<192101066.1663055.1623871300493@mail.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="a+XlyCz8hkeSG9dV" Content-Disposition: inline In-Reply-To: <192101066.1663055.1623871300493@mail.yahoo.com> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --a+XlyCz8hkeSG9dV Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, We generally prefer to do in-line replies (not top-posting) on these lists. So, more below. * LEROY TENNISON (leroy_tennison@prodigy.net) wrote: > Keep in mind that this can be accomplished in other ways depending on wh= at archive_command you're using.=A0 rsync, and sftp (I don't recommend scp = due to security concerns but it does compression as well) both have paramet= ers to do in-transit compression.=A0 If i remember correctly Postgresql com= pression must be enabled on both ends.=A0 I had a situation where that wasn= 't easy to do and opted for external (to Postgresql) compression. In general, rsync, sftp, and scp are very poor choices for archive command as they don't do anything to ensure that the WAL is actually written out to disk and also don't do a variety of other sensible checks to make sure the WAL matches the PG database, there's a history file for the timeline the WAL is on, etc. Thanks, Stephen --a+XlyCz8hkeSG9dV Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJgy3i3AAoJEO1sijiDR2RVAXIP/1WTlnPQUPc8NND5qaUA0T6P 28+GAN1O+2REBthLRXEtU/rmzstNr77mAeUc0L1zTPxbvhurP5/0Boue3nywl9XY fyTEabdofqteVjxSO6LLypsMjNMwz2+gMVBiEmZE5yZDrZCPZ2wnFi8vUt5slEjb 2SO9ffPsfgGg4HEK9uaCGM4756vgweWU4NBXbzSecyZOPxaS10ipwJUb6wKju1Yp CuQ5SXzZaQCe+rqXaLvuDmwaeRdMUCFliRGi79WxB6hC2v9+Ta1b3zPxVAlHzMLx A0bOwGOIE+bjPbDS6xmNIUbKdkr/V+keeN9K0cDekCtktfMfex8w6O5q8uO+tcn5 nKF5+bC7LLyd2polMwohYDSLVbAfPkcwxX9IlfFVzgR6vROi+q/IiWbfnWoTF4G/ NtWPqDg7RUmbzmYxX4ZgxqjzUkfqoFOvkrKXLyzwPt7tqkrsdODf7ZSlI2hpAJA8 N8OYstnR8b+g41WJ703A8bqTLozAk+JWrzPJaiJT5SzKVe1gVZxgrc4K0555uD5U Qx3n3tiebjERmP6nvQR7SmApo2eAPuh81IG9IBMB6s+AreYe1/yDK8yncoInhUEj Q7ime5LfCA7pQpejzfxTbqftQPWNu1Nce1sdOlP9NxYPfZ1f1uwDi2i/kjIAqcAk wz8Zx+DOS3FYmbdwBebe =IgMN -----END PGP SIGNATURE----- --a+XlyCz8hkeSG9dV-- From x4mmm@yandex-team.ru Mon Jun 28 10:36:25 2021 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lxocz-000279-Gv for pgsql-admin@arkaria.postgresql.org; Mon, 28 Jun 2021 10:36:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lxocy-0002yc-Gb for pgsql-admin@arkaria.postgresql.org; Mon, 28 Jun 2021 10:36:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lxocy-0002yU-4Z for pgsql-admin@lists.postgresql.org; Mon, 28 Jun 2021 10:36:32 +0000 Received: from forwardcorp1p.mail.yandex.net ([77.88.29.217]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lxocv-0003JJ-D8 for pgsql-admin@postgresql.org; Mon, 28 Jun 2021 10:36:31 +0000 Received: from iva8-d077482f1536.qloud-c.yandex.net (iva8-d077482f1536.qloud-c.yandex.net [IPv6:2a02:6b8:c0c:2f26:0:640:d077:482f]) by forwardcorp1p.mail.yandex.net (Yandex) with ESMTP id BFCA52E1487; Mon, 28 Jun 2021 13:36:26 +0300 (MSK) Received: from iva8-5ba4ca89b0c6.qloud-c.yandex.net (iva8-5ba4ca89b0c6.qloud-c.yandex.net [2a02:6b8:c0c:a8ae:0:640:5ba4:ca89]) by iva8-d077482f1536.qloud-c.yandex.net (mxbackcorp/Yandex) with ESMTP id yPRDiHPgSy-aQueNTGF; Mon, 28 Jun 2021 13:36:26 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex-team.ru; s=default; t=1624876586; bh=fLj1JWz2mo0AndfjgYJ4eNmH9AWdDSW2Q5rtoPKUpmA=; h=To:Message-Id:References:Date:Subject:Cc:In-Reply-To:From; b=FUFLFMzqL73ghy4iIRAoE3LGzMjWpi106S7Z/XnYFELueCaa32nnEfAuNi2c7/sN8 pYh1lBy2s5OBYMZoV8x1LM3KQV85bCE9UDAgRtUjCwOTmCVp6iN76K5BNn39sU01Ao ELcdwSGNjOsBZHzz0WoCE3nItub33TmyAd3Q/uPY= Authentication-Results: iva8-d077482f1536.qloud-c.yandex.net; dkim=pass header.i=@yandex-team.ru Received: from dynamic-ekb.dhcp.yndx.net (dynamic-ekb.dhcp.yndx.net [2a02:6b8:0:2807:512f:baf0:fe7e:4c76]) by iva8-5ba4ca89b0c6.qloud-c.yandex.net (smtpcorp/Yandex) with ESMTPSA id SrjgBR2sQ3-aQ0umx7N; Mon, 28 Jun 2021 13:36:26 +0300 (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client certificate not present) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.4\)) Subject: Re: compression in replication From: Andrey Borodin In-Reply-To: <1ltQeA-000URA-EE@unimaticaspa.it> Date: Mon, 28 Jun 2021 15:36:25 +0500 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <1ltQeA-000URA-EE@unimaticaspa.it> To: Massimo Ortensi X-Mailer: Apple Mail (2.3608.120.23.2.4) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Massimo! > 16 =D0=B8=D1=8E=D0=BD=D1=8F 2021 =D0=B3., =D0=B2 13:11, Massimo = Ortensi =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0= =BB(=D0=B0): >=20 > is there any way to compress the traffic for streaming replication ? libpq compression is being discussed here [0]. When the patch will be = committed subsequent PostgreSQL version will be able to benefit from = protocol copmression. Replication traffic also will be compressed. If = you wish, you can join efforts as the reviewer of that patch. As for now, you can use compressed archive recovery - many solutions = like WAL-G, pgBackRest, pg_probackup support compressing WALs with = decent compression algorithms. They also support parallel = upload\download of WAL segments, while replication is TCP-based = (serial). Keep in mind that archiving sends only at minimum one segment = (16Mb by default) at a time. Also, you will not be able to use features = like synchronous commit. Thanks! Best regards, Andrey Borodin. [0] = https://www.postgresql.org/message-id/flat/aad16e41-b3f9-e89d-fa57-fb4c694= bec25%40postgrespro.ru=