POSTGRES

Kubernetes Postgres Healthcheck

8 Troubleshooting Commands

Contributed by stewartshea

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`

Source Code Discoverable Troubleshooting CheatSheet

Kubernetes Postgres Healthcheck

3 Troubleshooting Commands

Contributed by stewartshea

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

Source Code