repo

Pig v1.9.0 adds one-command Xray client/server setup, automatic Pigsty repository-key preparation, and a refreshed 600-entry extension catalog. The default cargo-pgrx version is now 0.19.3; the embedded Pigsty version remains 4.5.0. Xray clients and …

Decision date: 2026-10-04 Status: Released in v1.9.0. Current reference: pig repo Scope: Installing the existing embedded Pigsty public key during repository configuration. Decision When a selected module contains an available pigsty-infra or …

Pig v1.8.1 is a safety, correctness, and maintenance release on top of v1.8.0. It hardens command initialization, privileged log access, repository and build workflows, release integrity, and structured-output redaction. It also refreshes the …

Decision date: 2026-08-14 Status: Implemented and released in pig v1.8.0. Current reference: pig sty boot Scope: Preparing a Pigsty controller and its package sources; not deploying a database cluster. Decision pig sty boot should be one native, …

Pig v1.8.0 makes Pigsty controller setup native. The two core setup commands, pig sty boot and pig sty conf, are now failure-aware Go workflows instead of wrappers around the legacy bootstrap and configure shell scripts. The release keeps the public …

Decision date: 2026-08-13 Status: Proposal; security mechanism, overlays, packaging, and path layout remain open. Current reference: pig ext and pig repo describe the v1 Catalog behavior. Scope: A candidate PIG 2.0 publication and consumption model …

Pig v1.7.0 is a repository compatibility and catalog release on top of v1.6.2. It makes China-mirror selection explicit, preserves native DNF module filtering by default, restores a streamlined EL7 repository catalog, and grows the bundled extension …

Today, let’s talk about Postpartum Care for Sows—a Chinese meme for the sort of absurdly specialized practical topic nobody expects to discuss. This time, the sow in question is my new open-source project, SOW. When you maintain a PostgreSQL …

Pig v1.6.2 is a feature and catalog release on top of v1.6.1. It grows the packaged extension catalog from 562 to 572, adds native Grafana dashboard schema v2 support, and improves local repository generation. The embedded Pigsty version remains …

I was updating the Redis module in Pigsty recently, adding Valkey as an alternative engine, and found a bug in an inherited packaging patch. In affected Valkey DEB packages, failed synchronous saves can corrupt used_memory until it reports a value …

pig v1.6.1 is a maintenance release on top of v1.6.0. It carries no new commands and no flag changes — the point of the release is the catalog that ships inside the binary. What changed Extension catalog refreshed. The embedded extension.csv is …

Pig v1.5.1 updates PG kernel forks to the latest package names. Highlights Add mirror/proxy mode to repo, build, sty, update, and extension update workflows; pig build rust -m also configures Cargo mirror settings with rsproxy.cn. Add explicit …

People often ask me: what exactly is Pigsty? My usual answer is: a PostgreSQL distribution. The next question is usually: what, then, is a “PostgreSQL distribution”? That is a good question. And the best place to begin is not databases, but operating …

Slide deck: Extensions for Everyone Part I. Introduction 0. Extensions for Everyone 00. Extensions for Everyone Hi everyone. This talk is called Extensions for Everyone. It is about delivering PostgreSQL extensions, and about how a shared delivery …

Refresh the extension catalog and increase the total available extensions to 510, with version bumps such as timescaledb 2.26.3, decoderbufs 3.5.0, pgclone 4.0.0, and nominatim_fdw 1.3. Bump the default pgrx version from 0.17.0 to 0.18.0 and align …

Directory: Chinese · English Extensions are the soul of PostgreSQL. Without them, PostgreSQL is just a very good relational database. With them, it becomes a platform that can swallow entire categories of database workloads. The problem is that the …

Today I put Claude Code to work on another genuinely useful project: a completely new PostgreSQL extension catalog. You can find it at pigsty.io/ext. This is already the catalog’s fifth incarnation. After a long detour, it has returned to the Hugo + …

Extension catalog and alias resolution enhancements: Introduce dynamic PG category alias resolution by PG major version. Add OS-level alias overrides (ansible/bootstrap) and converge unknown distro fallback to PGDG-only. Add aliases such as …

Fixes Preserve symlink semantics during build-tree migration and support cross-device moves. Handle a PostgreSQL log directory configured as the filesystem root without resolving files outside the intended directory. Allow pig repo rm to remove …

Extension Updates Total extensions reached 440 New extension: pg_ai_query 0.1.1 New extension: pg_textsearch 0.1.0 New extension: pg_clickhouse 0.1.0 pg_biscuit upgraded from 1.0 to 2.0.1 (switched to new repo, renamed to biscuit) pg_search upgraded …

Extension Updates timescaledb 2.23.1 -> 2.24.0 pg_search 0.20.0 -> 0.20.3 convert 0.0.4 -> 0.0.5 pglinter 1.0.0 -> 1.0.1 pgdd 0.6.0 -> 0.6.1 pg_session_jwt 0.3.3 -> 0.4.0 pg_anon 2.4.1 -> 2.5.1 pg_enigma 0.4.0 -> 0.5.0 wrappers 0.5.6 -> 0.5.7 …

Hi, I’m Feng Ruohang, author of Pigsty and an independent open-source contributor. Let’s talk about how to build a PostgreSQL distribution that is rooted in China and useful to the whole world. The question isn’t whether PG will win—it already has. …

Add new command: pig repo reload to update repo metadata Fix EL PGDG sysupdate aarch64 repo issue (now aarch64 repo ready) Fix EL10.aarch64 PGDG repo renaming issue Update extension versions Bump Pigsty version to 3.7.0 Checksums Copy all checksums …

My earlier post “PG ‘Export Controls’ and Supply-Chain Trust” drew a comment from an administrator at Tsinghua University’s TUNA mirror: “As a university mirror admin, calling us ‘lying flat’ or ‘irresponsible’ is unfair and demoralizing.” I replied: …

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 …

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 …

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 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 …

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 …

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

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 …

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 …

pig repo manages Linux package repositories. Use it to add or remove APT/YUM/DNF sources, refresh indexes, and create or extract offline bundles. repo create also supports macOS through SOW. Command Description Notes repo list Print available …

Install PIG with the Linux installer, a system package, or a release archive. The current version is v1.10.0. The download page lists all release files. Script installation On Linux, run: curl -fsSL https://repo.pigsty.io/pig | bash In mainland …

This tutorial installs PostgreSQL 18 and pgvector, starts a local test instance, and enables the extension in a database. Use a supported Linux test host with internet access and curl installed. You need root or sudo access. Run the commands in …