-
v0.8.0 Release Note
2021-03-16 in Releases
Pigsty v0.8.0 Pigsty now is in RC status with guaranteed API stability. New Features Service provision. full locale support. API Changes Role vip and haproxy are merged into service. …
-
Collation in PostgreSQL
2021-03-05 in PG Admin
Why does Pigsty default to locale=C and encoding=UTF8 when initializing PostgreSQL databases? The answer is simple: Unless you explicitly need LOCALE-specific features, you should never configure anything other than C.UTF8 for character encoding and …
-
PostgreSQL Replica Identity Explained
2021-03-03 in PG Admin
Introduction: DIY Logical Replication The concept of Replica Identity serves logical replication. Logical replication fundamentally works by decoding row-level changes (INSERT/UPDATE/DELETE) on published tables and applying them to subscribers. The …
-
PG Logical Replication Explained
2021-03-03 in PG Admin
Logical Replication Logical Replication is a method of replicating data objects and their changes based on the Replica Identity (typically primary keys) of data objects. The term Logical Replication contrasts with Physical Replication, where …
-
v0.7.0 Release Note
2021-03-01 in Releases
v0.7.0 Overview Monitor Only Deployment Now you can monitor existing postgres clusters without Pigsty provisioning solution. Intergration with other provisioning solution is available and under further test. Database/User Management Update …
-
Slow Query Diagnosis
2021-02-23 in PG Admin
You can’t optimize what you can’t measure Slow queries are the arch-enemy of online business databases. Knowing how to diagnose and locate slow queries is an essential skill for DBAs. This article introduces a general methodology for …
-
v0.6.0 Release Note
2021-02-19 in Releases
v0.6.0 Bug Fix pg_hba reset on patroni restart (patroni 2.0) #5 Merge Fix name of dashboard #1, Fix PG Overview Dashboard typo Fix default primary instance to pg-test-1 of cluster pg-test in sandbox environment Fix obsolete comments Enhancement …
-
v0.5.0 Release Note
2020-12-20 in Releases
v0.5.0 Pigsty now have an Official Site 🎉 ! New Features Add Database Provision Template Add Init Template Add Business Init Template Refactor HBA Rules variables Fix dashboards bugs. Move pg-cluster-replication to default dashboards Use ZJU …
-
v0.4.0 Release Note
2020-12-14 in Releases
v0.4.0 The second public beta (v0.4.0) of pigsty is available now ! 🎉 Monitoring System Skim version of monitoring system consist of 10 essential dashboards: PG Overview PG Cluster PG Service PG Instance PG Database PG Query PG Table PG Table …
-
v0.3.0 Release Note
2020-10-24 in Releases
v0.3.0 The first public beta (v0.3.0) of pigsty is available now ! 🎉 Monitoring System Skim version of monitoring system consist of 8 essential dashboards: PG Overview PG Cluster PG Service PG Instance PG Database PG Table Overview PG Table Catalog …