-
PGFS: Using DB as FS
2025-03-21 in Postgres
Recently, I received an interesting request from the Odoo community. They were grappling with a fascinating challenge: “If databases can do PITR (Point-in-Time Recovery), is there a way to roll back the file system as well?” The Birth of …
-
v3.3：Extension 404，Odoo, Dify, Supabase, Nginx Enhancement
2025-02-25 in Releases
After two months of careful polishing, Pigsty v3.3 is officially released! As an open-source, “battery-included” PostgreSQL distribution, Pigsty aims to optimize the PostgreSQL ecosystem and provide smooth self-hosting experience just …
-
PostgreSQL Frontier
2025-01-24 in Postgres
Dear readers, I’m off on vacation starting today—likely no new posts for about two weeks. Let me wish everyone a Happy New Year in advance. Of course, before heading out, I wanted to share some recent interesting developments in the Postgres …
-
v3.2: The pig CLI, ARM64 Repo, Self-hosting Supabase
2024-12-29 in Releases
The New Year is just around the corner, and Pigsty is celebrating the last release of 2024 with v3.2. This release introduces a new command-line tool, pig, and enhanced ARM extension support. Together, these features deliver a smooth PostgreSQL …
-
Pig, The PostgreSQL Extension Wizard
2024-12-29 in Postgres
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 …
-
Self-Hosting Supabase on PostgreSQL
2024-11-25 in Database
Supabase is great, own your own Supabase is even better. Here’s a comprehensive tutorial for self-hosting production-grade supabase on local/cloud VM/BMs. What is Supabase? Supabase is an open-source Firebase alternative, a Backend as a Service …
-
v3.1: PG 17 as default, Better Supabase & MinIO, ARM & U24 support
2024-11-24 in Releases
With the release of PostgreSQL 17.2 earlier this week, Pigsty promptly followed up with its v3.1 release. In this version, PostgreSQL 17 has been promoted as the default major version, and nearly 400 PostgreSQL extensions are now available out of the …
-
Don't Update! Rollback Issued on Release Day: PostgreSQL Faces a Major Setback
2024-11-16 in Postgres
As the old saying goes, never release code on Friday. Although PostgreSQL’s recent minor release carefully avoided a Friday launch, it still gave the community a full week of extra work — PostgreSQL will release an unscheduled emergency update …
-
PostgreSQL 12 Reaches End-of-Life as PG 17 Takes the Throne
2024-11-14 in Postgres
According to PostgreSQL’s versioning policy, PostgreSQL 12, released in 2019, officially exits its support lifecycle today (November 14, 2024). PostgreSQL 12’s final minor version, 12.21, released today (November 14, 2024), marks the end …
-
The idea way to install PostgreSQL Extensions
2024-11-02 in Postgres
PostgreSQL Is Eating the Database World through the power of extensibility. With 400 extensions powering PostgreSQL, we may not say it’s invincible, but it’s definitely getting much closer. I believe the PostgreSQL community has reached a …