PostgreSQL Mage
Ruohang Feng @Vonng / Pigsty
PostgreSQL ecosystem news, plus development, operations, internals and tuning.
Urgent Advisory: Pause PostgreSQL Minor-Release Installs and Upgrades
The PostgreSQL 18.2 minor-release train introduced regressions in substring() and WAL replay. Hold off on fresh deployments and upgrades, then update promptly after the out-of-cycle releases ship on …
First Chinese PostgreSQL Vendor on the PGConf.dev Main Stage
Three years, three CFP submissions, and finally a full session talk at PGConf.dev 2026—likely the first time a homegrown Chinese PostgreSQL vendor (a one-man database shop) takes the main stage to …
From AGPL to Apache: Why I Changed Pigsty's License
Pigsty switched from AGPLv3 to Apache 2.0. Aren't you worried about freeloaders? Freeloaders welcome — if you want to become the Debian of databases, a permissive license is table stakes.
How to Actually Do PostgreSQL High Availability
A deep dive into the SOTA approach for PostgreSQL HA. RTO/RPO breakdown, from theory to production. If you're still wrestling with PG HA, this might save you years.
How to Get Up to Speed with PostgreSQL Fast
People keep asking me how to get started with PostgreSQL. Instead of repeating myself, here is a 10-minute guide that sets you up with a production-grade environment and a patient AI tutor.
Git for Data: Instant PostgreSQL Database Cloning
How to instantly clone a massive PostgreSQL database without consuming extra storage? PostgreSQL 18 and XFS can spark some serious magic.
Why PostgreSQL Will Dominate the AI Era
Context window economics, the polyglot persistence problem, and the triumph of zero-glue architecture make PostgreSQL the database king of the AI era.
Forging a China-Rooted, Global PostgreSQL Distro
PostgreSQL already won. The real battle is the distro layer. Will Chinese developers watch from the sideline or craft a PG “Ubuntu” for the world?
Is PostgreSQL 18 Ready for Production?
With PostgreSQL 18.1 out and the extension ecosystem caught up, Pigsty v3.7 now defaults to PG 18. Time to take it into production.
PG Extension Cloud: Unlocking PostgreSQL’s Entire Ecosystem
Free, open, no VPN. Install PostgreSQL and 431 extensions on 14 Linux distros × 6 PG versions via native RPM/DEB—and a tiny CLI.
The PostgreSQL 'Supply Cut' and Trust Issues in Software Supply Chain
PostgreSQL official repos cut off global mirror sync channels, open-source binaries supply disrupted, revealing the true colors of various database and cloud vendors.
Column: Postgres Mage
Navigation of articles about PostgreSQL development, administration, principles, ecosystem, tools, architecture design, performance optimization, troubleshooting, and more.
PostgreSQL Dominates Database World, but Who Will Devour PG?
The same forces that once led MongoDB and MySQL toward closure are now at work in the PostgreSQL ecosystem. The PG world needs a distribution that represents "software freedom" values.
PostgreSQL Has Dominated the Database World
The 2025 SO global developer survey results are fresh out, and PostgreSQL has become the most popular, most loved, and most wanted database for the third consecutive year. Nothing can stop PostgreSQL …
PGDG Cuts Off Mirror Sync Channel
PGDG cuts off FTP rsync sync channels, global mirror sites universally disconnected - this time they really strangled global users' supply chain.
Postgres Extension Day - See You There!
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
OrioleDB is Coming! 4x Performance, Eliminates Pain Points, Storage-Compute Separation
A PG kernel fork acquired by Supabase, claiming to solve PG's XID wraparound problem, eliminate table bloat issues, improve performance by 4x, and support cloud-native storage. Now part of the Pigsty …
OpenHalo: MySQL Wire-Compatible PostgreSQL is Here!
What? PostgreSQL can now be accessed using MySQL clients? That's right, openHalo, which was open-sourced on April Fool's Day, provides exactly this capability and has now joined the Pigsty kernel …
PGFS: Using Database as a Filesystem
Leverage JuiceFS to turn PostgreSQL into a filesystem with PITR capabilities!
PostgreSQL Ecosystem Frontier Developments
Sharing some interesting recent developments in the PG ecosystem.
Pig, The Postgres Extension Wizard
Why would we need yet another package manager for PostgreSQL & extensions?
Don't Upgrade! Released and Immediately Pulled - Even PostgreSQL Isn't Immune to Epic Fails
Never deploy on Friday, or you'll be working all weekend! PostgreSQL minor releases were pulled on the day of release, requiring emergency rollback.
PostgreSQL 12 End-of-Life, PG 17 Takes the Throne
PG17 achieved extension ecosystem adaptation in half the time of PG16, with 300 available extensions ready for production use. PG 12 officially exits support lifecycle.
The Ideal Way to Deliver PostgreSQL Extensions
PostgreSQL is eating the database world through extensibility. This post introduces the Pigsty extension repository, which packaged 390 PostgreSQL extensions at launch and keeps growing through the …
Urgent Advisory: Pause PostgreSQL Minor-Release Installs and Upgrades
The PostgreSQL 18.2 minor-release train introduced regressions in substring() and WAL replay. Hold off on fresh deployments and upgrades, then update promptly after the out-of-cycle releases ship on …
First Chinese PostgreSQL Vendor on the PGConf.dev Main Stage
Three years, three CFP submissions, and finally a full session talk at PGConf.dev 2026—likely the first time a homegrown Chinese PostgreSQL vendor (a one-man database shop) takes the main stage to …
From AGPL to Apache: Why I Changed Pigsty's License
Pigsty switched from AGPLv3 to Apache 2.0. Aren't you worried about freeloaders? Freeloaders welcome — if you want to become the Debian of databases, a permissive license is table stakes.
How to Actually Do PostgreSQL High Availability
A deep dive into the SOTA approach for PostgreSQL HA. RTO/RPO breakdown, from theory to production. If you're still wrestling with PG HA, this might save you years.
How to Get Up to Speed with PostgreSQL Fast
People keep asking me how to get started with PostgreSQL. Instead of repeating myself, here is a 10-minute guide that sets you up with a production-grade environment and a patient AI tutor.
Git for Data: Instant PostgreSQL Database Cloning
How to instantly clone a massive PostgreSQL database without consuming extra storage? PostgreSQL 18 and XFS can spark some serious magic.
Why PostgreSQL Will Dominate the AI Era
Context window economics, the polyglot persistence problem, and the triumph of zero-glue architecture make PostgreSQL the database king of the AI era.
Forging a China-Rooted, Global PostgreSQL Distro
PostgreSQL already won. The real battle is the distro layer. Will Chinese developers watch from the sideline or craft a PG “Ubuntu” for the world?
Is PostgreSQL 18 Ready for Production?
With PostgreSQL 18.1 out and the extension ecosystem caught up, Pigsty v3.7 now defaults to PG 18. Time to take it into production.
PG Extension Cloud: Unlocking PostgreSQL’s Entire Ecosystem
Free, open, no VPN. Install PostgreSQL and 431 extensions on 14 Linux distros × 6 PG versions via native RPM/DEB—and a tiny CLI.
The PostgreSQL 'Supply Cut' and Trust Issues in Software Supply Chain
PostgreSQL official repos cut off global mirror sync channels, open-source binaries supply disrupted, revealing the true colors of various database and cloud vendors.
Column: Postgres Mage
Navigation of articles about PostgreSQL development, administration, principles, ecosystem, tools, architecture design, performance optimization, troubleshooting, and more.
PostgreSQL Dominates Database World, but Who Will Devour PG?
The same forces that once led MongoDB and MySQL toward closure are now at work in the PostgreSQL ecosystem. The PG world needs a distribution that represents "software freedom" values.
PostgreSQL Has Dominated the Database World
The 2025 SO global developer survey results are fresh out, and PostgreSQL has become the most popular, most loved, and most wanted database for the third consecutive year. Nothing can stop PostgreSQL …
PGDG Cuts Off Mirror Sync Channel
PGDG cuts off FTP rsync sync channels, global mirror sites universally disconnected - this time they really strangled global users' supply chain.
Postgres Extension Day - See You There!
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
OrioleDB is Coming! 4x Performance, Eliminates Pain Points, Storage-Compute Separation
A PG kernel fork acquired by Supabase, claiming to solve PG's XID wraparound problem, eliminate table bloat issues, improve performance by 4x, and support cloud-native storage. Now part of the Pigsty …
OpenHalo: MySQL Wire-Compatible PostgreSQL is Here!
What? PostgreSQL can now be accessed using MySQL clients? That's right, openHalo, which was open-sourced on April Fool's Day, provides exactly this capability and has now joined the Pigsty kernel …
PGFS: Using Database as a Filesystem
Leverage JuiceFS to turn PostgreSQL into a filesystem with PITR capabilities!
PostgreSQL Ecosystem Frontier Developments
Sharing some interesting recent developments in the PG ecosystem.
Pig, The Postgres Extension Wizard
Why would we need yet another package manager for PostgreSQL & extensions?
Don't Upgrade! Released and Immediately Pulled - Even PostgreSQL Isn't Immune to Epic Fails
Never deploy on Friday, or you'll be working all weekend! PostgreSQL minor releases were pulled on the day of release, requiring emergency rollback.
PostgreSQL 12 End-of-Life, PG 17 Takes the Throne
PG17 achieved extension ecosystem adaptation in half the time of PG16, with 300 available extensions ready for production use. PG 12 officially exits support lifecycle.
The Ideal Way to Deliver PostgreSQL Extensions
PostgreSQL is eating the database world through extensibility. This post introduces the Pigsty extension repository, which packaged 390 PostgreSQL extensions at launch and keeps growing through the …
Urgent Advisory: Pause PostgreSQL Minor-Release Installs and Upgrades
The 18.2 minor-release train introduced two bugs. Hold off on fresh deployments and upgrades, then update promptly after 18.3 ships next week. One week ago, the PostgreSQL community shipped its routine February minor releases, and Pigsty v4.1 …
The 18.2 minor-release train introduced two bugs. Hold off on fresh deployments and upgrades, then update promptly after 18.3 ships next week. One week ago, the PostgreSQL community shipped its routine February minor releases, and Pigsty v4.1 …
First Chinese PostgreSQL Vendor on the PGConf.dev Main Stage
This morning I got the email: my talk proposal, “Extensions for Everyone”, has been officially accepted for a full session at PGConf.dev 2026. That means a lot to me personally. Having my work in the PostgreSQL ecosystem recognized by the core …
This morning I got the email: my talk proposal, “Extensions for Everyone”, has been officially accepted for a full session at PGConf.dev 2026. That means a lot to me personally. Having my work in the PostgreSQL ecosystem recognized by the core …
From AGPL to Apache: Why I Changed Pigsty's License
Pigsty is a batteries-included, local-first PostgreSQL distribution. With the v4.0 release, I finally did something I’d been considering for a while: switching from AGPLv3 back to Apache 2.0. Here’s why I changed it, what it means, and my take on …
Pigsty is a batteries-included, local-first PostgreSQL distribution. With the v4.0 release, I finally did something I’d been considering for a while: switching from AGPLv3 back to Apache 2.0. Here’s why I changed it, what it means, and my take on …
How to Actually Do PostgreSQL High Availability
Seven or eight years ago, I was managing a hundred large-scale PostgreSQL clusters across 200+ beefy bare-metal servers, and I started evaluating HA solutions. I went through every option with a name: Patroni, Corosync + Pacemaker, repmgr, Stolon, …
Seven or eight years ago, I was managing a hundred large-scale PostgreSQL clusters across 200+ beefy bare-metal servers, and I started evaluating HA solutions. I went through every option with a name: Patroni, Corosync + Pacemaker, repmgr, Stolon, …
How to Get Up to Speed with PostgreSQL Fast
People keep asking me the same question lately: “How do I get started with PostgreSQL?” It has come up often enough that I figured I should write a proper tutorial and answer everyone at once. The best way to learn PostgreSQL is learning by …
People keep asking me the same question lately: “How do I get started with PostgreSQL?” It has come up often enough that I figured I should write a proper tutorial and answer everyone at once. The best way to learn PostgreSQL is learning by …
Git for Data: Instant PostgreSQL Database Cloning
Every programmer has used git clone. Hit enter, wait a few seconds, and a complete code repository appears on your disk. But what about databases? Want a copy of production data for your test environment? The traditional approach is pg_dump + …
Every programmer has used git clone. Hit enter, wait a few seconds, and a complete code repository appears on your disk. But what about databases? Want a copy of production data for your test environment? The traditional approach is pg_dump + …
Why PostgreSQL Will Dominate the AI Era
In the Agent era, the underlying logic of software architecture has changed. Over the past decade, we’ve built microservices and “polyglot persistence” to accommodate the collaboration boundaries of human teams, fragmenting our systems into scattered …
In the Agent era, the underlying logic of software architecture has changed. Over the past decade, we’ve built microservices and “polyglot persistence” to accommodate the collaboration boundaries of human teams, fragmenting our systems into scattered …
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. …
Is PostgreSQL 18 Ready for Production?
In Beware the Bleeding Edge: A PostgreSQL Storage Engine Postmortem, I briefly shared my rule of thumb for adopting new PostgreSQL major versions: wait until the second point release (x.1) before putting a new major version into production. Now that …
In Beware the Bleeding Edge: A PostgreSQL Storage Engine Postmortem, I briefly shared my rule of thumb for adopting new PostgreSQL major versions: wait until the second point release (x.1) before putting a new major version into production. Now that …
PG Extension Cloud: Unlocking PostgreSQL’s Entire Ecosystem
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 …
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 …
The PostgreSQL 'Supply Cut' and Trust Issues in Software Supply Chain
This month saw a high-profile “open source supply cut” incident — KubeSphere deleting images and running away, but there’s another slightly more subtle “chokepoint case” I mentioned last month — “Chokepoint: PGDG Cuts Mirror Sync Channels”. This …
This month saw a high-profile “open source supply cut” incident — KubeSphere deleting images and running away, but there’s another slightly more subtle “chokepoint case” I mentioned last month — “Chokepoint: PGDG Cuts Mirror Sync Channels”. This …
Column: Postgres Mage
Ecosystem PGEXT.DAY 2025, See You There OrioleDB Is Coming! OpenHalo: MySQL-Compatible PG PGFS: Database as Filesystem PostgreSQL Ecosystem Frontier Progress Pig on Elephant: PG Package Manager Pig Release Day Halt: PG Also Can’t Escape Major …
Ecosystem PGEXT.DAY 2025, See You There OrioleDB Is Coming! OpenHalo: MySQL-Compatible PG PGFS: Database as Filesystem PostgreSQL Ecosystem Frontier Progress Pig on Elephant: PG Package Manager Pig Release Day Halt: PG Also Can’t Escape Major …
PostgreSQL Dominates Database World, but Who Will Devour PG?
Percona is a banner-bearer and major third-party vendor in the MySQL ecosystem, and has been advancing into the PostgreSQL space in recent years. The English original of this article was published on the Percona blog this morning. Of course, Percona …
Percona is a banner-bearer and major third-party vendor in the MySQL ecosystem, and has been advancing into the PostgreSQL space in recent years. The English original of this article was published on the Percona blog this morning. Of course, Percona …
PostgreSQL Has Dominated the Database World
The 2025 StackOverflow Global Developer Survey results are fresh out, with high-quality questionnaire feedback from 50,000 developers across 177 countries and regions. As a database veteran, I’m most interested in the “Database” section of this …
The 2025 StackOverflow Global Developer Survey results are fresh out, with high-quality questionnaire feedback from 50,000 developers across 177 countries and regions. As a database veteran, I’m most interested in the “Database” section of this …
PGDG Cuts Off Mirror Sync Channel
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 …
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 …
Postgres Extension Day - See You There!
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. …
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. …
OrioleDB is Coming! 4x Performance, Eliminates Pain Points, Storage-Compute Separation
OrioleDB, which sounds interesting - though “Oriole” means a type of bird (黄鹂 in Chinese), so it should actually be translated as “Oriole Database” rather than “Cookie Database” or “Bird Database”. The name doesn’t matter much; what’s important is …
OrioleDB, which sounds interesting - though “Oriole” means a type of bird (黄鹂 in Chinese), so it should actually be translated as “Oriole Database” rather than “Cookie Database” or “Bird Database”. The name doesn’t matter much; what’s important is …
OpenHalo: MySQL Wire-Compatible PostgreSQL is Here!
What? PostgreSQL can now be accessed using MySQL clients? That’s right, openHalo, which was open-sourced on April Fool’s Day, provides exactly this capability — allowing users to simultaneously access and manage the same database using both MySQL and …
What? PostgreSQL can now be accessed using MySQL clients? That’s right, openHalo, which was open-sourced on April Fool’s Day, provides exactly this capability — allowing users to simultaneously access and manage the same database using both MySQL and …
PGFS: Using Database as a Filesystem
A few days ago, I received a request from the Odoo community asking: “Databases support PITR (Point-in-Time Recovery), but is there a way to roll back the filesystem as well?” Why the “PGFS” Idea? From a veteran database engineer’s perspective, this …
A few days ago, I received a request from the Odoo community asking: “Databases support PITR (Point-in-Time Recovery), but is there a way to roll back the filesystem as well?” Why the “PGFS” Idea? From a veteran database engineer’s perspective, this …
PostgreSQL Ecosystem Frontier Developments
Dear readers, I’m starting my vacation today. I might stop posting for two weeks, so Happy New Year in advance. Of course, before starting vacation, this article shares some interesting recent developments in the PG ecosystem. Yesterday I also …
Dear readers, I’m starting my vacation today. I might stop posting for two weeks, so Happy New Year in advance. Of course, before starting vacation, this article shares some interesting recent developments in the PG ecosystem. Yesterday I also …
Pig, The Postgres Extension Wizard
Title: Meet 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 …
Title: Meet 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 …
Don't Upgrade! Released and Immediately Pulled - Even PostgreSQL Isn't Immune to Epic Fails
The old saying goes: never deploy code on Friday. The PostgreSQL minor releases issued two days ago deliberately avoided Friday deployment, but still gave the community a week’s worth of extra work — the PostgreSQL community will release an unusual …
The old saying goes: never deploy code on Friday. The PostgreSQL minor releases issued two days ago deliberately avoided Friday deployment, but still gave the community a week’s worth of extra work — the PostgreSQL community will release an unusual …
PostgreSQL 12 End-of-Life, PG 17 Takes the Throne
According to PostgreSQL’s versioning policy, PostgreSQL 12, released in 2019, will officially exit its support lifecycle today (2024-11-14). PG 12’s final minor version is 12.21, released on 2024-11-14, and this will be PG 12’s ultimate version. …
According to PostgreSQL’s versioning policy, PostgreSQL 12, released in 2019, will officially exit its support lifecycle today (2024-11-14). PG 12’s final minor version is 12.21, released on 2024-11-14, and this will be PG 12’s ultimate version. …
The Ideal Way to Deliver PostgreSQL Extensions
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 …
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 …