v2.5.0 Ubuntu/Debian Support

[Vonng]

Check v2.5.0 for the latest release note

Highlights

• Ubuntu / Debian Support: bullseye, bookworm, jammy, focal
• Dedicate yum/apt repo on repo.pigsty.cc and mirror on packagecloud.io
• Anolis OS Support (EL 8.8 Compatible)
• PG Major Candidate: Use PostgreSQL 16 instead of PostgreSQL 14.
• Extensions Update:
  • Bump PostGIS version to v3.4 on el8, el9, ubuntu22, keep postgis 33 on EL7
  • Remove extension pg_embedding because it is no longer maintained, use pgvector instead.
  • New extension on EL: pointcloud with LIDAR data type support.
  • Include columnar extension hydra and remove citus from default installed extension list.
  • Recompile pg_filedump as PG major version independent package.

Ubuntu Support

Pigsty has two ubuntu LTS support: 22.04 (jammy) and 20.04 (focal), and ship corresponding offline packages for them.

Some parameters need to be specified explicitly when deploying on Ubuntu, please refer to ubuntu.yml

• repo_upstream: Adjust according to ubuntu / debian repo.
• repo_packages: Adjust according to ubuntu / debian naming convention
• node_repo_local_urls: use the default value: ['deb [trusted=yes] http://${admin_ip}/pigsty ./']
• node_default_packages ：
  • zlib -> zlib1g, readline -> libreadline-dev
  • vim-minimal -> vim-tiny, bind-utils -> dnsutils, perf -> linux-tools-generic,
  • new packages acl to ensure ansible tmp file privileges are set correctly
• infra_packages: replace all _ with - in names, and replace postgresql16 with postgresql-client-16
• pg_packages: replace all _ with - in names, patroni-etcd not needed on ubuntu
• pg_extensions: different naming convention, no passwordcheck_cracklib on ubuntu.
• pg_dbsu_uid: You have to manually specify pg_dbsu_uid on ubuntu, because PGDG deb package does not specify pg dbsu uid.

API Changes

default values of following parameters have changed:

• repo_modules: infra,node,pgsql,redis,minio

• repo_upstream: Now add Pigsty Infra/MinIO/Redis/PGSQL modular upstream repo.

• repo_packages: remove unused karma,mtail,dellhw_exporter and pg 14 extra extensions, adding pg 16 extra extensions.

• pg_extensions: citus is nolonger installed by default, and passwordcheck_cracklib is installed by default

  - pg_repack_${pg_version}* wal2json_${pg_version}* passwordcheck_cracklib_${pg_version}*
  - postgis34_${pg_version}* timescaledb-2-postgresql-${pg_version}* pgvector_${pg_version}*

---

This discussion was created from the release v2.5.0 Ubuntu/Debian Support.