Tags: postgres
-
Instantly Clone PostgreSQL Databases—No Black Magic Required
Six months ago, on January 8, 2026, I wrote Git for Data: Instant PostgreSQL Database and Instance Cloning, introducing a new feature in PostgreSQL 18 and Pigsty v4.0: instant database cloning. With filesystem copy-on-write (CoW) and PostgreSQL 18’s …
Six months ago, on January 8, 2026, I wrote Git for Data: Instant PostgreSQL Database and Instance Cloning, introducing a new feature in PostgreSQL 18 and Pigsty v4.0: instant database cloning. With filesystem copy-on-write (CoW) and PostgreSQL 18’s …
-
What Is a PostgreSQL Distribution?
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 …
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 …
-
pig v1.5.0
Pig v1.5.0 is a PostgreSQL operations release for day-to-day DBA work. It adds local database clone/fork workflows, clarifies the boundaries between pg, pt, pb, and pitr, and tightens preview, confirmation, and structured-output behavior for …
Pig v1.5.0 is a PostgreSQL operations release for day-to-day DBA work. It adds local database clone/fork workflows, clarifies the boundaries between pg, pt, pb, and pitr, and tightens preview, confirmation, and structured-output behavior for …
-
One Grammar for Dangerous Work: PIG's Operations CLI Safety Contract
Decision date: 2026-07-02 Status: Released for pg, pb, pt, and pitr by v1.5.0; the 2026-08-29 do and build proxy refinements were released in v1.8.1. Current reference: pig pg, pig pb, pig pitr, pig do, and pig build Scope: PIG-owned operational …
Decision date: 2026-07-02 Status: Released for pg, pb, pt, and pitr by v1.5.0; the 2026-08-29 do and build proxy refinements were released in v1.8.1. Current reference: pig pg, pig pb, pig pitr, pig do, and pig build Scope: PIG-owned operational …
-
pig v1.3.2
Routine maintenance release. Refresh a batch of extension version metadata and catalog entries. Add the pig pg tune subcommand to generate PostgreSQL tuning parameters from hardware resources and workload profiles. Add pdu and pgdog source package …
Routine maintenance release. Refresh a batch of extension version metadata and catalog entries. Add the pig pg tune subcommand to generate PostgreSQL tuning parameters from hardware resources and workload profiles. Add pdu and pgdog source package …
-
The 70% Tuner: Defining the Boundary of pig pg tune
Decision date: 2026-03-21 Status: Implemented on 2026-03-23 and released in pig v1.3.2. Current reference: pig pg tune Scope: A deterministic first-pass configuration for one local PostgreSQL instance, not a complete production design service. …
Decision date: 2026-03-21 Status: Implemented on 2026-03-23 and released in pig v1.3.2. Current reference: pig pg tune Scope: A deterministic first-pass configuration for one local PostgreSQL instance, not a complete production design service. …
-
pig v1.0.0
This release introduces three major new subcommand groups (pig pg, pig pt, pig pb) for managing PostgreSQL, Patroni, and pgBackRest, along with an orchestrated PITR command and enhanced extension availability display. New Commands pig pg - PostgreSQL …
This release introduces three major new subcommand groups (pig pg, pig pt, pig pb) for managing PostgreSQL, Patroni, and pgBackRest, along with an orchestrated PITR command and enhanced extension availability display. New Commands pig pg - PostgreSQL …
-
Forging a China-Rooted, Global PostgreSQL Distro
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. …
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. …
-
Pig, The Postgres Extension Wizard
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 …
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 pe
pig pe (aliases: pgexp, pgexporter) is a legacy convenience wrapper for a running pg_exporter. It reads the default metrics and statistics endpoints and can request a configuration reload. It is not a general or versioned pg_exporter client. pig pe …
pig pe (aliases: pgexp, pgexporter) is a legacy convenience wrapper for a running pg_exporter. It reads the default metrics and statistics endpoints and can request a configuration reload. It is not a general or versioned pg_exporter client. pig pe …
-
pig postgres
The pig pg command (alias pig postgres) manages local PostgreSQL servers and databases. It wraps local primitives such as pg_ctl, psql, and vacuumdb; use pig pt for Patroni cluster operations and pig pitr for orchestrated PITR. pig pg - Local …
The pig pg command (alias pig postgres) manages local PostgreSQL servers and databases. It wraps local primitives such as pg_ctl, psql, and vacuumdb; use pig pt for Patroni cluster operations and pig pitr for orchestrated PITR. pig pg - Local …