Documentation
Complete guide to managing PostgreSQL databases with pgcli.
PostgreSQL 18 — production ready.
- Quick Start — Install and basic usage
- Backup — Snapshots and pgBackRest management
- Restore — Point-in-time recovery (PITR)
- Replication — Read-only replicas and failover
- Extensions — Install and manage PostgreSQL extensions
- Addons — PgBouncer connection pooler and other addons
- KV Cache — Lightweight Redis alternative for key-value caching
- Auto-start on Boot — Start instances and services automatically after reboot
- Toolbox — Standalone utilities, including ZFS storage management
Which pgcli components and features work on Linux vs macOS
Install pgcli and create your first PostgreSQL instance.
Create isolated environments on a single host using namespaces
Backup guide for pgcli
Point-in-Time Recovery (PITR) guide for pgcli
Replica (read-only standby) guide for pgcli
Patroni high-availability clusters with pgcli — pg ha commands, dynamic configuration, REST API, extensions, cluster backup and restore, direct SQL
Failover: Replica Promotion guide for pgcli
Mint your own self-signed TLS certificates with pg cert and serve them from the store addons
Configure pgcli to automatically start PostgreSQL instances and services after a host reboot
PostgreSQL Extensions guide for pgcli
pgcli addon management guide
Clone guide for pgcli
Data Import/Export guide for pgcli
PostgreSQL health inspection report guide for pgcli
Hardware-aware postgresql.conf tuning for pgcli instances and Patroni clusters
PostgreSQL KV cache functions for lightweight Redis replacement
Standalone tools that extend pgcli beyond PostgreSQL management
SQL commands guide for pgcli
Destroy an instance and remove its configuration
View PostgreSQL and addon console output logs
Administration guide for pgcli