Module: PGSQL

The most advanced open-source relational database in the world with HA, PITR, IaC and more!

Overview of PostgreSQL in Pigsty

PostgreSQL entities and key concepts

Define roles & clusters for PostgreSQL

Define business users & roles in PostgreSQL

Define business databases in PostgreSQL

Exposing service for PostgreSQL

Host-Based Authentication in Pigsty

battery-included access control model in Pigsty

Maintain PostgreSQL cluster in Pigsty?

How to perform base backup & PITR with pgBackRest?

How to use Pigsty to monitor remote (existing) PostgreSQL instances?

How to migrate existing postgres into Pigsty-managed cluster?

Last modified 2023-02-27: add v2.0 images and docs (5b09f12)