Architecture
Pigsty’s modular architecture, compose modules in a declarative manner
Categories: Concept
Users
Define business users & roles in PostgreSQL, which is the object created by SQL CREATE USER/ROLE
Module:
Categories:
Databases
Define business databases in PostgreSQL, which is the object create by SQL CREATE DATABASE
Module:
Categories:
Services
Define and create new services, and expose them via haproxy
Module:
Categories:
Extensions
Define, Create, Install, Enable Extensions in Pigsty
Module:
Categories:
Authentication
Host-Based Authentication in Pigsty, how to manage HBA rules in Pigsty?
Module:
Categories:
Concept
Learn about core concept about Pigsty: architecture, cluster models, infra, PG HA, PITR, and service access.
Module:
Self-Signed CA
Pigsty comes with a set of self-signed CA PKI for issuing SSL certs to encrypt network traffic.
Module:
Categories:
High Availability
Pigsty uses Patroni to achieve high availability for PostgreSQL, ensuring automatic failover.
Categories:
Access Control
Built-in roles system, and battery-included access control model in Pigsty.
Module:
Categories:
Access Control
Pigsty has moderate security best-practice: password & certs, built-in ACLs, encrypted network traffics and cold backups