Postgres (Patroni) Service
- Service Overview
- Alerts: https://alerts.gitlab.net/#/alerts?filter=%7Btype%3D%22patroni%22%2C%20tier%3D%22db%22%7D
- Label: gitlab-com/gl-infra/production~“Service::Patroni”
Logging
Section titled “Logging”Troubleshooting Pointers
Section titled “Troubleshooting Pointers”- ApdexSLOViolation
- ErrorSLOViolation
- CI Runner Troubleshooting Guide
- Interacting with Consul
- Disaster Recovery Gameday Schedule
- Google Cloud Snapshots
- Measuring Recovery Activities
- Zonal and Regional Recovery Guide
- Alerting
- ../monitoring/prometheus-failing-rule-evaluations.md
- Diagnosis with Kibana
- Recovering from CI Patroni cluster lagging too much or becoming completely broken
- ../pgbouncer/patroni-consul-postgres-pgbouncer-interactions.md
- Add a new PgBouncer instance
- PgBouncer connection management and troubleshooting
- Removing a PgBouncer instance
- ../pgbouncer/service-pgbouncer.md
- Postgres Replicas
- Container Registry Database Index Bloat
- A survival guide for SREs to working with Sidekiq at GitLab
- Teleport Administration
- How to use flamegraphs for performance profiling
- Deleted Project Restoration
- Rails is down
- Application Database Queries
- Steps to create (or recreate) a Standby CLuster using a Snapshot from a Production cluster as Master cluster (instead of pg_basebackup)
- Check the status of transaction wraparound Runbook
- Custom PostgreSQL Package Build Process for Ubuntu Xenial 16.04
- database_peak_analysis.md
- How and when to deprovision the db-benchmarking environment
- Patroni GCS Snapshots
- Geo Patroni Cluster Management
- gitlab-com-wale-backups.md
- gitlab-com-walg-backups.md
- Log analysis on PostgreSQL, Pgbouncer, Patroni and consul Runbook
- Making a manual clone of the DB for the data team
- Mapping Postgres Statements, Slowlogs, Activity Monitoring and Traces
- OS Upgrade Reference Architecture
- Patroni Cluster Management
- performance-degradation-troubleshooting.md
- PostgreSQL HA
- pg_collect_query_data.md
- Postgresql minor upgrade
- Pg_repack using gitlab-pgrepack
- pgbadger Runbook
- GitLab application-side reindexing
- postgres-backups-verification-failures.md
- postgres-checkup.md
- Dealing with Data Corruption in PostgreSQL
- Diagnosing long running transactions
- postgres.md
- postgresql-backups-wale-walg.md
- postgresql-buffermapping-lwlock-contention.md
- PostgreSQL
- postgresql-locking.md
- Adding a PostgreSQL replica
- Credential rotation
- PostgreSQL VACUUM
- Postgresql
- Primary Database Node CPU Saturation Analysis
- How to provision the benchmark environment
- SQL query analysis and optimization for Postgres
- Rails SQL Apdex alerts
- Rotating Rails’ PostgreSQL password
- Scale Down Patroni
- Scale Up Patroni
- High-level performance analysis and troubleshooting of a Postgres node
- Handling Unhealthy Patroni Replica
- Roles/Users grants and permission Runbook
- using-wale-gpg.md
- Zero Downtime Postgres Database Decomposition