Обсуждение: updated extensions for postgres 18
Hey everyone, this is my first email to this list, so feel free to point me out to the proper place.
Some packages are missing for postgres 18:
* pg_qualstats: https://github.com/powa-team/pg_qualstats/releases/tag/2.1.2
* pg_qualstats: https://github.com/powa-team/pg_qualstats/releases/tag/2.1.2
* postgres-hll: https://github.com/citusdata/postgresql-hll/releases/tag/v2.18
Where can I patch the build files to add the new versions?
Sebastian Webber
Hi Sebastian, It looks like all of these have packaging repos on salsa.debian.org: * https://salsa.debian.org/postgresql/pg-qualstats * https://salsa.debian.org/postgresql/pglogical * https://salsa.debian.org/postgresql/pgaudit * https://salsa.debian.org/postgresql/postgresql-hll * https://salsa.debian.org/postgresql/pldebugger * https://salsa.debian.org/postgresql/omnidb-plpgsql-debugger -- Bradford
Hi, On Thu, 2025-09-25 at 19:50 -0300, Sebastian Webber wrote: > * postgres-hll: > https://github.com/citusdata/postgresql-hll/releases/tag/v2.18 hll 2.18 cannot be built against v18: https://github.com/citusdata/postgresql-hll/issues/166 Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor BlueSky: @devrim.gunduz.org , @gunduz.org
Вложения
Em sex., 26 de set. de 2025 às 01:41, Bradford Boyle <bradford.d.boyle@gmail.com> escreveu:
Hi Sebastian,
hey, thanks for the reply!
It looks like all of these have packaging repos on salsa.debian.org:
* https://salsa.debian.org/postgresql/pg-qualstats
* https://salsa.debian.org/postgresql/pglogical
* https://salsa.debian.org/postgresql/pgaudit
* https://salsa.debian.org/postgresql/postgresql-hll
* https://salsa.debian.org/postgresql/pldebugger
* https://salsa.debian.org/postgresql/omnidb-plpgsql-debugger
Ok, but i'm trying to use the packages in the pgdg repo, please see:
root@221f91773525:~# cat /etc/apt/sources.list.d/pgdg.list
deb http://apt.postgresql.org/pub/repos/apt/ jammy-pgdg main 18
root@221f91773525:~# apt update
Hit:1 http://apt.postgresql.org/pub/repos/apt jammy-pgdg InRelease
Hit:2 http://ports.ubuntu.com/ubuntu-ports jammy InRelease
Hit:3 http://ports.ubuntu.com/ubuntu-ports jammy-updates InRelease
Hit:4 http://ports.ubuntu.com/ubuntu-ports jammy-backports InRelease
Hit:5 http://ports.ubuntu.com/ubuntu-ports jammy-security InRelease
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
2 packages can be upgraded. Run 'apt list --upgradable' to see them.
root@221f91773525:~# export FULL_VERSION=18.0* pg=18
apt install \
postgresql-${pg}-pg-qualstats \
postgresql-${pg}-pglogical \
postgresql-${pg}-pgaudit \
postgresql-${pg}-hll \
postgresql-${pg}-pldebugger
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
E: Unable to locate package postgresql-18-pglogical
E: Unable to locate package postgresql-18-hll
E: Unable to locate package postgresql-18-pldebugger
Sebastian Webber
Em sex., 26 de set. de 2025 às 07:17, Devrim Gündüz <devrim@gunduz.org> escreveu:
Hi,
On Thu, 2025-09-25 at 19:50 -0300, Sebastian Webber wrote:
> * postgres-hll:
> https://github.com/citusdata/postgresql-hll/releases/tag/v2.18
hll 2.18 cannot be built against v18:
https://github.com/citusdata/postgresql-hll/issues/166
Thanks for pointing this out. I will open a new issue in the project.
Sebastian Webber
Chegou a ver o meu blog? Dá uma olhada no que eu ando aprontando: http://swebber.me
On Fri, Sep 26, 2025 at 7:45 AM Sebastian Webber <sebastian@swebber.me> wrote: > Ok, but i'm trying to use the packages in the pgdg repo, please see: The packages in the pgdg repo are built from the packaging repos hosted on salsa.debian.org. Here are the Jenkins job definitions: https://salsa.debian.org/postgresql/apt.postgresql.org/-/blob/master/jenkins/pgapt-jobs.yaml -- Bradford