PATRONI

Icon
Icon Kubernetes PostgreSQL Triage

Icon 1 7 Troubleshooting Commands

Icon 2 Contributed by Shea Stewart

Icon 2 Codecollection: rw-public-codecollection

Runs multiple Kubernetes and psql commands to report on the health of a postgres cluster.

Tasks:
  • Get Standard Resources
  • Describe Custom Resources
  • Get Pod Logs & Events
  • Get Pod Resource Utilization
  • Get Running Configuration
  • Get Patroni Output
  • Run DB Queries
IconSource Code
Icon Kubernetes PostgreSQL Query

Icon 1 1 Troubleshooting Commands

Icon 2 Contributed by Shea Stewart

Icon 2 Codecollection: rw-public-codecollection

Runs a postgres SQL query and pushes the returned result into a report. During execution, the SQL query should be passed to a Kubernetes workload that has access to the psql binary. The workload will run the query and return the results from stdout.

Tasks:
  • Run Postgres Query And Results to Report
IconSource Code
Icon Kubernetes Patroni Health Check

Icon 1 1 Troubleshooting Commands

Icon 2 Contributed by Jonathan Funk

Icon 2 Codecollection: rw-public-codecollection

Uses kubectl (or equivalent) to query the state of a patroni cluster and determine if it's healthy.

Tasks:
  • Determine Patroni Health
IconSource Code
Icon Kubernetes Patroni Lag Health

Icon 1 1 Troubleshooting Commands

Icon 2 Contributed by Jonathan Funk

Icon 2 Codecollection: rw-public-codecollection

Detects and reinitializes laggy Patroni cluster members which are unable to catchup in replication using kubectl and patronictl.

Tasks:
  • Determine Patroni Health
IconSource Code IconTroubleshooting CheatSheet
Icon Kubernetes Patroni Lag Metric

Icon 1 1 Troubleshooting Commands

Icon 2 Contributed by Jonathan Funk

Icon 2 Codecollection: rw-public-codecollection

Measures the maximum replica lag across a Patroni cluster.

Tasks:
  • Measure Patroni Member Lag
IconSource Code
Icon Kubernetes Triage Patroni

Icon 1 3 Troubleshooting Commands

Icon 2 Contributed by Jonathan Funk

Icon 2 Codecollection: rw-public-codecollection

Taskset to triage issues related to patroni.

Tasks:
  • Get Patroni Status
  • Get Pods Status
  • Fetch Logs
IconSource Code
Icon Kubernetes Postgres Healthcheck

Icon 1 8 Troubleshooting Commands

Icon 2 Contributed by stewartshea

Icon 2 Codecollection: rw-cli-codecollection

Runs a series of tasks to check the overall health of a postgres cluster and to provide detailed information useful for debugging or reviewing configurations.

Tasks:
  • List Resources Related to Postgres Cluster `OBJECT_NAME` in Namespace `NAMESPACE`
  • Get Postgres Pod Logs & Events for Cluster `OBJECT_NAME` in Namespace `NAMESPACE`
  • Get Postgres Pod Resource Utilization for Cluster `OBJECT_NAME` in Namespace `NAMESPACE`
  • Get Running Postgres Configuration for Cluster `OBJECT_NAME` in Namespace `NAMESPACE`
  • Get Patroni Output and Add to Report for Cluster `OBJECT_NAME` in Namespace `NAMESPACE`
  • Fetch Patroni Database Lag for Cluster `OBJECT_NAME` in Namespace `NAMESPACE`
  • Check Database Backup Status for Cluster `OBJECT_NAME` in Namespace `NAMESPACE`
  • Run DB Queries for Cluster `OBJECT_NAME` in Namespace `NAMESPACE`
IconSource Code IconDiscoverable IconTroubleshooting CheatSheet
Icon Kubernetes Postgres Healthcheck

Icon 1 3 Troubleshooting Commands

Icon 2 Contributed by stewartshea

Icon 2 Codecollection: rw-cli-codecollection

Runs multiple Kubernetes and psql commands to report on the health of a postgres cluster. Produces a value between 0 (completely failing thet test) and 1 (fully passing the test). Checks for database lag & backup health.

Tasks:
  • Fetch Patroni Database Lag
  • Check Database Backup Status for Cluster `${OBJECT_NAME}` in Namespace `${NAMESPACE}`
  • Generate Namspace Score
IconSource Code