pgcli Simplify PostgreSQL management

Create, start, stop, and destroy isolated PostgreSQL instances with one command.

Full, differential, and incremental snapshots with pgBackRest and a shared backup container.

Point-in-time recovery (PITR) to any moment after your first backup, with dry-run preview.

Create read-only replicas with WAL streaming, automatic slot management, and cascading replication.

3-step manual failover — promote a replica, clean up the old primary, and repoint remaining replicas.

Install and manage 440+ PostgreSQL extensions from the Pigsty catalog, baked into container images.

Stream-clone an instance or remote database into a new instance with no temporary files on disk.

Export and import databases in custom or SQL format, with gzip compression and piping between instances.

Run SQL, container commands, or interactive psql sessions — locally or against remote databases via DSN.

Shell completion, config management, PostgreSQL tuning, and instance rebuild for a fresh start.