PIG Blog

WeChat link PostgreSQL’s killer feature is extensibility. PostGIS, pgvector, pg_duckdb, pg_search—extensions turn PG into GIS engine, vector DB, analytics warehouse, search cluster. But compiling and shipping them reliably across distros is a …

Launch the new PGEXT.CLOUD extension catalog Remove unnecessary sudo usage, now can be used inside docker Allow using pg18, pg17 arg format in pig ext link command Add environment var PIG_NO_SUDO to force not using sudo RPM Changelog: Add PG 18 …

Add support for Debian 13 and EL 10 distributions Massive extension updates to the latest versions with PostgreSQL 18 support Almost all Rust extensions now support PG 18 via pgrx 0.16.1 pig build command overhaul pig build pkg <pkg> will now …

Use official PG 18 repo instead of testing repo Add v prefix when specifying pigsty version string Improved network connectivity check Checksums Copy all checksums Download asset FileChecksum pig_0.6.2-1_amd64.deb Linuxamd64MD5 01f5b7dc…8347 …

I was recently chatting with my friend Yurii, the founder of Omnigres. He wants to hire a PostgreSQL packaging expert and has even coined a title for the role: EEE, or Extension Ecosystem Engineer. It is an interesting idea. The job description is …

This month, KubeSphere removed its container images, prompting a debate about open-source supply chains. A quieter disruption had already affected PostgreSQL: PGDG had closed its mirror synchronization channels. For me, that disruption tested how …

Add el10 and debian 13 trixie support stub Launch the dedicated PIG website Rebuild with go 1.25 and CI/CD pipeline Use PIGSTY PGDG mirror in mainland China Remove unused pgdg-el10fix repo Use Pigsty WiltonDB mirror Add EL 10 dedicated epel repo pig …

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, PGConf.dev, will be held in Montreal in May. Postgres Extensions Day takes place the day before it, with a focus on extension development, packaging, and release. The agenda has just been released, with 14 …

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

This release introduced a PIG homepage alongside 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

New extensions pg_documentdb_core and FerretDB VectorChord-bm25 (vchord_bm25) 0.1.0 pg_tracing 0.1.2 pg_curl 2.4 pgxicor 0.1.0 pgsparql 1.0 pgjq 0.1.0 hashtypes 0.1.5 db_migrator 1.0.0 pg_cooldown 0.1 Extension updates citus 13.0.0 -> 13.0.1 …

New extensions pg_documentdb_core and FerretDB VectorChord-bm25 (vchord_bm25) 0.1.0 pg_tracing 0.1.2 pg_curl 2.4 pgxicor 0.1.0 pgsparql 1.0 pgjq 0.1.0 hashtypes 0.1.5 db_migrator 1.0.0 pg_cooldown 0.1 Extension updates citus 13.0.0 -> 13.0.1 …

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

PIG is a Go command-line tool for installing PostgreSQL and extensions through the system package manager. It selects packages for the operating system, CPU architecture, and PostgreSQL version, then uses APT, YUM, or DNF to install them. 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 340 PostgreSQL extensions as RPM / DEB packages for mainstream Linux distributions. The live Pigsty Extension …