Version v3.7.0 of the documentation is no longer actively maintained. The site that you are currently viewing is an archived snapshot. For up-to-date documentation, see the latest version.
PostgreSQL
Concept
PostgreSQL cluster architecture and concept
Reliable service access via lb, proxy, pool
Define, create, and manage business databases
Define, create, and manage users and roles
Host-Based Authentication in Pigsty
Access Control with default roles and privileges
Administration
Replace vanilla PostgreSQL with exotic kernel forks
Harness the synergistic power of PostgreSQL extensions
Describe and configure PostgreSQL clusters
Customize postgres cluster with 120 parameters
Run administrative tasks on PostgreSQL clusters
Control primitives with Ansible playbooks
Backup and point-in-time recovery
Zero-downtime blue-green deployment
Monitor existing PostgreSQL or RDS
Visualized information with Grafana dashboards
PostgreSQL cluster architecture and concept
Describe and configure PostgreSQL clusters
customize postgres cluster with 121 parameters
run administrative tasks
control primitives
Monitor existing PostgreSQL or RDS
frequently asked questions
In this context, User refers to logical objects created by SQL CREATE USER / ROLE
In this context, Database refers to the object created by SQL CREATE DATABASE.
reliable service access via lb, proxy, pool
Host-Based Authentication in Pigsty
Access Control with default roles and privileges
check visualized information
zero-downtime blue-green deployment
Backup and point-in-time recovery
Replace vanilla PostgreSQL with exotic kernel forks
Harness the synergistic power of PostgreSQL extensions