Instance Management
Create, start, stop, and destroy isolated PostgreSQL instances with one command.
PostgreSQL instance manager
Using PostgreSQL databases as naturally as breathing — and extending them just as naturally, with a rich catalog of PostgreSQL extensions and companion infrastructure around your database and storage. pgcli is your lightsaber: as powerful in a Jedi’s hand, letting you forge your database and storage foundation with ease.
Key features
Create, start, stop, and destroy isolated PostgreSQL instances with one command.
Full, differential, and incremental snapshots with pgBackRest, and point-in-time recovery to any moment after them.
Read-only replicas with WAL streaming and cascading replication; promote one to take over when the primary is lost.
Patroni high availability — automatic failover, a DCS-backed cluster, cross-host members, cluster PITR, and direct SQL.
One-command companion containers around an instance or cluster: PgBouncer, etcd, PgDog, PostgREST, HAProxy, MinIO / silo / rustfs, Redis, and Predixy.
Install and manage 440+ PostgreSQL extensions from the Pigsty catalog, baked into container images.
Ready to get started?Install pgcli and create your first PostgreSQL instance in minutes.