deb cannot be installed on Debian 11

[enp6]

After downloading pg_analytics-v0.5.10-pg16-amd64-ubuntu2204.deb and executing the installation, I received these messages directly.

dpkg-deb: error: archive './pg_analytics-v0.5.10-pg16-amd64-ubuntu2204.deb' uses unknown compression for member 'control.tar.zst', giving up
dpkg: error processing archive ./pg_analytics-v0.5.10-pg16-amd64-ubuntu2204.deb (--install):
 dpkg-deb --control subprocess returned error exit status 2
Errors were encountered while processing:
 ./pg_analytics-v0.5.10-pg16-amd64-ubuntu2204.deb

[philippemnoel]

Ah yes, I've seen this issue before. We build for Debian 12/Ubuntu 22.04, and it uses a compression which is only in Debian 12 due to dpkg-deb.

There is probably a way to fix this, but I won't have time to look into this for a few days at least. I would recommend you simply compile from source, or use Debian 12. If you want to fix this issue, we'll be happy to merge your contribution to our CI. The file in question is: https://github.com/paradedb/paradedb/blob/dev/.github/workflows/publish-pg_analytics.yml

[DeoLeung]

https://unix.stackexchange.com/a/745467/328643

this is what i used before, unpack and repack it for lower debian version, not sure if it still works :)

[philippemnoel]

https://unix.stackexchange.com/a/745467/328643

this is what i used before, unpack and repack it for lower debian version, not sure if it still works :)

Thanks for sharing, I'll give this a try

[philippemnoel]

Hi @DeoLeung. Apologies for the delays in getting back to this. It is fixed in #1160