Architecture
PostgreSQL cluster architectures and implmenetation details.
PostgreSQL cluster architectures and implmenetation details.
Define business users & roles in PostgreSQL, which is the object created by SQL CREATE USER/ROLE
Define business databases in PostgreSQL, which is the object create by SQL CREATE DATABASE
Define and create new services, and expose them via haproxy
Define, Create, Install, Enable Extensions in Pigsty
Host-Based Authentication in Pigsty, how to manage HBA rules in Pigsty?
Configure your PostgreSQL cluster & instances according to your needs
Posts about Pigsty and PostgreSQL
Use PostgreSQL instead of static YAML config file as Ansible config inventory
Use PostgreSQL instead of default SQLite, as the backend storage for Grafana
List of PostgreSQL extensions supported by Pigsty, and their compatibility on different OS distros.
The most advanced open-source relational database in the world with HA, PITR, IaC and more!
How to manage PostgreSQL cluster with ansible playbooks
Administration standard operation procedures to manage PostgreSQL clusters in production environment.
Pigsty uses Patroni to achieve high availability for PostgreSQL, ensuring automatic failover.
Built-in roles system, and battery-included access control model in Pigsty.
How to perform base backup & PITR with pgBackRest?
How to migrate existing postgres into Pigsty-managed cluster with mimial downtime? The blue-green online migration playbook
How PostgreSQL monitoring works, and how to monitor remote (existing) PostgreSQL instances?
Pigsty utilizes pgBackRest for PostgreSQL point-in-time recovery, allowing users to roll back to any point within the backup policy limits.
Grafana dashboards provided by Pigsty
Pigsty employs HAProxy for service access, offering optional pgBouncer for connection pooling, and optional L2 VIP and DNS access.
Pigsty PGSQL module metric list
Pigsty has moderate security best-practice: password & certs, built-in ACLs, encrypted network traffics and cold backups
Pigsty PGSQL module frequently asked questions