MIME-Version: 1.0
From: Didier Michel <didier.michel@enterprisedb.com>
Date: Fri, 12 Aug 2022 16:52:36 +0200
Message-ID: 
 <CAHCS47HiFv3HqBTXESfmuksDQixYpyekU+wYjB7W8jYrY=C4LA@mail.gmail.com>
Subject: Issues with PG15beta3
To: pgsql-pkg-debian@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000075fb1d05e60c6fec"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHCS47HiFv3HqBTXESfmuksDQixYpyekU%2BwYjB7W8jYrY%3DC4LA%40mail.gmail.com>
Precedence: bulk

--00000000000075fb1d05e60c6fec
Content-Type: text/plain; charset="UTF-8"

Hello,

I am integrating new pg_basebackup zstd compression functionality in Barman
for compressed backup.

I do encounter two main issues when using zstd compression algorithm:

On ubuntu 18.04 :
- command exemple:  /usr/bin/pg_basebackup --dbname=dbname=replication
host=db options=-cdatestyle=iso port=5432 replication=true
user=barman_streaming
application_name=barman_streaming_backup -v --no-password
--pgdata=/var/lib/barman/main/base/20220811T162557/data --no-slot
--wal-method=none
--checkpoint=fast
 --format=tar
--compress=zstd:level=5
Interesting part is "--compress=zstd:level=5"
- pg_basebackup response:

pg_basebackup: checkpoint completed
pg_basebackup: error: this build does not support zstd compression


On Ubuntu 20.04 and 22.04:
The same command works. But When I try to introduce workers option (ie
"--compress=zstd:level=5,workers=2") it fails with following error:

pg_basebackup: checkpoint completed
pg_basebackup: error: could not set compression worker count to 2:
Unsupported parameter


Unless I have misused pg_basebackup (which is completely possible), I am
wondering if there could be an issue with PG packaging  or compilation
(especially for workers that triggers threads)

Hoping this can help deliver PG15.
Regards.

Didier Michel

--00000000000075fb1d05e60c6fec
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello,<br><br>I am integrating new pg_basebackup zstd comp=
ression functionality in Barman for compressed backup.<br><br>I do encounte=
r two main issues when using zstd compression algorithm:<br><br>On ubuntu 1=
8.04 :=C2=A0<br>- command exemple:=C2=A0=C2=A0<span style=3D"color:rgb(128,=
128,128);background-color:rgb(43,43,43);font-family:&quot;JetBrains Mono&qu=
ot;,monospace;font-size:9.8pt" class=3D"">/usr/bin/pg_basebackup --dbname=
=3Ddbname=3Dreplication host=3Ddb options=3D-cdatestyle=3Diso port=3D5432 r=
eplication=3Dtrue user=3Dbar</span><span style=3D"color:rgb(128,128,128);ba=
ckground-color:rgb(43,43,43);font-family:&quot;JetBrains Mono&quot;,monospa=
ce;font-size:9.8pt" class=3D"">man_streaming application_name=3Dbarman_stre=
aming_backup -v --no-password <br>--pgdata=3D/var/lib/barman/main/base/2022=
0811T162557/data --no-slot --wal-method=3Dnone <br>--checkpoint=3Dfast=C2=
=A0<br><span style=3D"font-size:9.8pt" class=3D"">=C2=A0--format=3Dtar <br>=
--compress=3Dzstd:level=3D5</span><br></span>Interesting part is &quot;--co=
mpress=3Dzstd:level=3D5&quot;<br>- pg_basebackup response:=C2=A0<div class=
=3D""><pre style=3D"background-color:rgb(43,43,43);color:rgb(169,183,198);f=
ont-family:&quot;JetBrains Mono&quot;,monospace;font-size:9.8pt"><span styl=
e=3D"color:rgb(128,128,128)">pg_basebackup: checkpoint completed<br></span>=
<span style=3D"color:rgb(128,128,128)" class=3D"">pg_basebackup: error: thi=
s build does not support zstd compression</span></pre></div><div class=3D""=
><br></div><div class=3D""><br></div><div class=3D"">On Ubuntu 20.04 and 22=
.04:<br>The same command works. But When=C2=A0I try to introduce workers op=
tion (ie &quot;--compress=3Dzstd:level=3D5,workers=3D2&quot;) it fails with=
 following error:</div><div class=3D""><pre style=3D"background-color:rgb(4=
3,43,43);color:rgb(169,183,198);font-family:&quot;JetBrains Mono&quot;,mono=
space;font-size:9.8pt"><span style=3D"color:rgb(128,128,128)">pg_basebackup=
: checkpoint completed<br></span><span style=3D"color:rgb(128,128,128)" cla=
ss=3D"">pg_basebackup: error: could not set compression worker count to 2: =
Unsupported parameter</span></pre></div><div class=3D""><br>Unless I have m=
isused pg_basebackup (which is completely=C2=A0possible), I am wondering if=
 there could be an issue with PG packaging=C2=A0 or compilation (especially=
=C2=A0for workers that triggers threads)<br><br>Hoping this can help delive=
r PG15.<br>Regards.<br><br>Didier Michel</div></div>

--00000000000075fb1d05e60c6fec--