Which pgcli components and features work on Linux vs macOS

Install pgcli and create your first PostgreSQL instance.

Manage pgcli resources declaratively with the bundled Ansible playbooks — instances, replicas, add-ons, Patroni HA clusters, and S3 stores

Create isolated environments on a single host using namespaces

Backup guide for pgcli

Back up regular pgcli instances straight to the shared S3 repository — pg create –backup-target s3, no dual-write, promote-time selection

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