[Feature]: Support recent barman cloud compression

[elliottneilclark]

This is a mirror issue of cloudnative-pg/cloudnative-pg/issues/6363.

Request:

Please update to the latest barman cloud 3.12.0 or later ( 3.12.1 is the latest at time of filing this issues). This update gives access to zstd, lz4, and XZ. While testing HBase and larger distributed databases we found ZSTD and lz4 as great options, so I would really like to use those rather than snappy.

Barman Release Notes:

https://github.com/EnterpriseDB/barman/releases/tag/release%2F3.12.0

Improve WAL compression with zstd, lz4 and xz algorithms

Introduced support for xz compression on WAL files. It can be enabled by specifying
xz in the compression server parameter. WALs will be compressed when entering
the Barman's WAL archive. For the cloud, it can be enabled by specifying --xz
when running barman-cloud-wal-archive.

Introduced support for zstandard compression on WAL files. It can be enabled by
specifying zstd in the compression server parameter. WALs will be compressed
when entering the Barman's WAL archive. For the cloud, it can be enabled by
specifying --zstd when running barman-cloud-wal-archive.

Introduced support for lz4 compression on WAL files. It can be enabled by
specifying lz4 in the compression server parameter. WALs will be compressed
when entering the Barman's WAL archive. For the cloud, it can be enabled by
specifying --lz4 when running barman-cloud-wal-archive.

References: BAR-265, BAR-423, BAR-264.

Alternative

For now Snappy is the best for our cases.