PIG Blog

New extension catalog: https://ext.pgsty.com New subcommand: pig install to simplify pig ext install Add new kernel support: percona with pg_tde Add new package: Google GenAI MCP toolbox for databases Add new repo: percona repo and clickhouse repo …

Recently, while building Pigsty offline packages, I discovered that the PostgreSQL version installed during local testing wasn’t quite right - 17.4 was behind the latest 17.5 by one minor version. Also, when testing on EL10, I found several …

Update the extension list to 422 New extension: pgactive from AWS Bump timescaledb to 2.20.3 Bump citus to 13.1.0 Bump vchord to 0.4.3 Bug fix pgvectorscale debian/ubuntu pg17 failure Bump kubernetes repo to 1.33 Bump default pigsty version to 3.5.0 …

Update the extension list to 421 Add openhalo/orioledb support for Debian / Ubuntu pgdd 0.6.0 (pgrx 0.14.1) convert 0.0.4 (pgrx 0.14.1) pg_idkit 0.3.0 (pgrx 0.14.1) pg_tokenizer.rs 0.1.0 (pgrx 0.13.1) pg_render 0.1.2 (pgrx 0.12.8) pgx_ulid 0.2.0 …

Update the extension list to 414 Add citus_wal2json and citus_pgoutput to pig ext scan mapping Add PG 18 beta repo Add PG 18 package alias v0.4.1 Released 2025-05-07 View release Source · tar.gz Source · zip pgsty/pig

Updated extension list, available extensions reached 407 Added pig do subcommand for executing Pigsty playbook tasks Added pig pt subcommand for wrapping Patroni command-line tools Added extension aliases: openhalo and orioledb Added gitlab-ce / …

The annual PostgreSQL developer conference will be held in Montreal in May. Like the first PG Con.Dev, there’s also an additional dedicated event - Postgres Extensions Day, focusing on all aspects of PG extension development, delivery, and release. …

curl https://repo.pigsty.io/pig | bash -s 0.3.4 Routine extension metadata update Use aliyun epel mirror instead of broken tsinghua tuna mirror Bump pigsty version string Add gitlab repo to the repo list v0.3.4 Released 2025-04-05 View release …

Add pig build dep command to install extension build dependencies Update default repo list Use pigsty.io mirror for mssql module (wiltondb/babelfish) Merge docker module into infra Remove pg16/17 from el7 target Allow installing extensions in el7 …

Enhancement New extensions Use upx to reduce binary size Remove embedded pigsty to reduce binary size v0.3.2 Released 2025-03-21 View release Source · tar.gz Source · zip pgsty/pig

Routine bugfix Fix repo format string Fix ext info links Update pg_mooncake metadata v0.3.1 Released 2025-03-19 View release Source · tar.gz Source · zip pgsty/pig

The pig project now has a new homepage, along with the PostgreSQL Extension Catalog. v0.3.0 Released 2025-02-24 View release Source · tar.gz Source · zip pgsty/pig

404 Extensions Available in Pig v0.2.2 v0.2.2 Released 2025-02-22 View release Source · tar.gz Source · zip pgsty/pig

v0.2.0 Released 2025-02-14 View release Source · tar.gz Source · zip pgsty/pig

v0.1.4 Released 2025-02-12 View release Source · tar.gz Source · zip pgsty/pig

v0.1.3, routine update, with 390 extensions available now! v0.1.3 Released 2025-01-23 View release Source · tar.gz Source · zip pgsty/pig

351 PostgreSQL Extensions, including the powerful postgresql-anonymizer 2.0 v0.1.2 Released 2025-01-12 View release Source · tar.gz Source · zip pgsty/pig

Update Extension List v0.1.1 Released 2025-01-09 View release Source · tar.gz Source · zip pgsty/pig

Ever wished installing or upgrading PostgreSQL extensions didn’t feel like digging through outdated readmes, cryptic configure scripts, or random GitHub forks & patches? The painful truth is that Postgres’s richness of extension often comes at the …

pig CLI v0.1 released v0.1.0 Released 2024-12-29 View release Source · tar.gz Source · zip pgsty/pig

Genesis Release v0.0.1 Released 2024-12-23 View release Source · tar.gz Source · zip pgsty/pig

PostgreSQL Is Eating the Database World through the power of extensibility. When this post was first published, the repository packaged 390 PostgreSQL extensions as RPM / DEB packages for mainstream Linux distributions. The live Pigsty Extension …