This chapter contains runbooks how to perform specific day-two operations.
Details about how to generate a pgBadger report from the distributed logs server.
Steps about how to perform a volume downsize
Details about how to restore a StackGres cluster backup.
Manage your PostgreSQL cluster using declarative StackGres CRs
Expertly-tuned PostgreSQL by default
Provide custom configuration on top of vanilla PostgreSQL
High availability and automated failover
Automated backups and backup lifecycle management
Integrated server-side connection pooling
Distributed logs for Postgres and Patroni
Observability: Prometheus Grafana integration, Envoy proxy
Fully-featured management web console
Automated day-2 operations such as minor & major PostgreSQL version upgrades, container upgrades, controlled restarts, vacuum, or repack
Make use of advanced replication modes, including async, sync and group replication.
PostgreSQL extensions (150+ provided)
Very active ecosystem (open source, public issue tracking, Slack, commercial support)
How to add Postgres alerts to your Prometheus installation
How recover Postgres PGDATA from an existing volume
How to run Supabase on top of Stackgres
How to install locally K3S and f Stackgres
How to run FerretDB on top of Stackgres
How to run Metis on top of Stackgres
Backing up large database in seconds using snapshots
How to configure Gateway API
Achieve Zero-Downtime for Maintenance Tasks