Architecture

Introduction to the overall architecture and implementation details of PostgreSQL clusters.

Entity-Relationship

Introduction to the entity-relationship model, ER diagram, entity definitions, and naming conventions for PostgreSQL clusters in Pigsty.

Components

Introduction to the components in PostgreSQL clusters in Pigsty, as well as their interactions and dependencies.

Identity

Introduction to entity identity identifiers for PostgreSQL clusters in Pigsty: naming conventions, design philosophy, and usage.

High Availability Cluster

In-depth introduction to the architecture design, component interaction, failure scenarios and recovery mechanisms of PostgreSQL high availability clusters in Pigsty.

Point-in-Time Recovery

Introduction to the implementation architecture, principles, trade-offs and implementation details of PostgreSQL Point-in-Time Recovery in Pigsty.

Security and Compliance

Detailed explanation of security features and compliance capabilities of PostgreSQL clusters in Pigsty


Last Modified 2026-01-09: add supabase asciinema demo (693cfa8)