Pigsty Blog Articles

One-click installs, a beta CLI, and Loki-based logging make Pigsty easier to land.

Yesterday I gave a live presentation in the PostgreSQL Chinese community, introducing the open-source PostgreSQL full-stack solution: Pigsty.

Services are now first-class objects, so you can define any routing policy—built-in HAProxy, L4 VIPs, or your own balancer.

Databases are the core component of information systems, relational databases are the absolute backbone of databases, and PostgreSQL is the world's most advanced open source relational database. With such favorable timing and positioning, how can it not achieve great success?

Monitor-only deployments unlock hybrid fleets, while DB/user provisioning APIs get a serious cleanup.

v0.6 reworks the provisioning flow, adds exporter toggles, and makes the monitoring stack portable across environments.

Pigsty v0.5 introduces declarative database templates so roles, schemas, extensions, and ACLs can be described entirely in YAML.

What? Don't know what COLLATION is? Remember one thing: using C COLLATE is always the right choice!

How to implement relatively complex fuzzy search logic in PostgreSQL?

This article introduces the principles and best practices of logical replication in PostgreSQL 13.