Pigsty Blog Articles
Pigsty v2.4: Monitor Cloud RDS
October 01, 2023 in Pigsty
Pigsty v2.4 delivers PostgreSQL 16 GA support, RDS/PolarDB monitoring, Redis Sentinel HA, and a wave of new extensions including Apache AGE, zhparser, and pg_embedding.
Pigsty v2.4 delivers PostgreSQL 16 GA support, RDS/PolarDB monitoring, Redis Sentinel HA, and a wave of new extensions including Apache AGE, zhparser, and pg_embedding.
How to Use pg_filedump for Data Recovery?
September 27, 2023 in PostgreSQL
Backups are a DBA's lifeline — but what if your PostgreSQL database has already exploded and you have no backups? Maybe `pg_filedump` can help you!
Backups are a DBA's lifeline — but what if your PostgreSQL database has already exploded and you have no backups? Maybe `pg_filedump` can help you!
What Kind of Self-Reliance Do Infrastructure Software Need?
August 31, 2023 in Database
When we talk about self-reliance and control, what are we really talking about? Operational self-reliance vs. R&D self-reliance - what nations/users truly need is the former, not flashy "self-research".
When we talk about self-reliance and control, what are we really talking about? Operational self-reliance vs. R&D self-reliance - what nations/users truly need is the former, not flashy "self-research".
Pigsty v2.3: Richer App Ecosystem
August 24, 2023 in Pigsty
Pigsty v2.3 adds FerretDB MongoDB support, NocoDB integration, L2 VIP for node clusters, PostgreSQL security patches, and Redis 7.2.
Pigsty v2.3 adds FerretDB MongoDB support, NocoDB integration, L2 VIP for node clusters, PostgreSQL security patches, and Redis 7.2.
Vector is the New JSON
August 06, 2023 in PostgreSQL
Vectors will become a key element in building applications, just like JSON historically. PostgreSQL leads the AI era with vector extensions.
Vectors will become a key element in building applications, just like JSON historically. PostgreSQL leads the AI era with vector extensions.
Pigsty v2.2: Monitoring System Reborn
July 22, 2023 in Pigsty
Pigsty v2.2 delivers a complete monitoring dashboard overhaul built on Grafana 10, a 42-node production simulation sandbox, Pigsty's own RPM repos, and UOS compatibility.
Pigsty v2.2 delivers a complete monitoring dashboard overhaul built on Grafana 10, a 42-node production simulation sandbox, Pigsty's own RPM repos, and UOS compatibility.
Cloud Computing Mudslide: Deconstructing Public Cloud with Data
July 08, 2023 in Cloud
Once upon a time, "going to cloud" was almost politically correct in tech circles, but few people use hard data to analyze the trade-offs involved. I'm willing to be this skeptic: let me use hard data and personal stories to explain the traps and value of public cloud rental models.
Once upon a time, "going to cloud" was almost politically correct in tech circles, but few people use hard data to analyze the trade-offs involved. I'm willing to be this skeptic: let me use hard data and personal stories to explain the traps and value of public cloud rental models.
DHH: Cloud-Exit Saves Over Ten Million, More Than Expected!
July 07, 2023 in Cloud
DHH migrated their seven cloud applications from AWS to their own hardware. 2024 is the first year of full savings realization. They're delighted to find the savings exceed initial estimates.
DHH migrated their seven cloud applications from AWS to their own hardware. 2024 is the first year of full savings realization. They're delighted to find the savings exceed initial estimates.
Cloud Exit Odyssey: Time to Leave Cloud?
July 07, 2023 in Cloud
This article chronicles the complete journey of 37Signals moving off the cloud, led by DHH. Valuable reference for both cloud-bound and cloud-native enterprises.
This article chronicles the complete journey of 37Signals moving off the cloud, led by DHH. Valuable reference for both cloud-bound and cloud-native enterprises.
FinOps: Endgame Cloud-Exit
July 06, 2023 in Cloud
At the SACC 2023 FinOps session, I fiercely criticized cloud vendors. This is a transcript of my speech, introducing the ultimate FinOps concept — Cloud-Exit and its implementation path.
At the SACC 2023 FinOps session, I fiercely criticized cloud vendors. This is a transcript of my speech, introducing the ultimate FinOps concept — Cloud-Exit and its implementation path.