↓ Skip to main content
Vonng
Background Image

Incident Report

Incident Report: Patroni Failure Due to Time Travel
·145 words·1 min
PostgreSQL PG Management Incident Report
Machine restarted due to failure, NTP service corrected PG time after PG startup, causing Patroni to fail to start.
Incident: PostgreSQL Extension Installation Causes Connection Failure
·437 words·3 mins
PostgreSQL PG Administration Extensions Incident Report
Today encountered an interesting case where a customer reported database connection issues caused by extensions.
Incident Report: Connection Pool Contamination Caused by pg_dump
·1237 words·6 mins
PostgreSQL PG Management Incident Report
Sometimes, interactions between components manifest in subtle ways. For example, using pg_dump to export data from a connection pool can cause connection pool contamination issues.
PostgreSQL Data Page Corruption Repair
·2729 words·13 mins
PostgreSQL PG Management Data Corruption Incident Report
Using binary editing to repair PostgreSQL data pages, and how to make a primary key query return two records.
Incident Report: PostgreSQL Transaction ID Wraparound
·968 words·5 mins
PostgreSQL PG Management Incident Report
XID WrapAround is perhaps a unique type of failure specific to PostgreSQL
Incident Report: Integer Overflow from Rapid Sequence Number Consumption
·651 words·4 mins
PostgreSQL PG Management Incident Report
If you use Integer sequences on tables, you should consider potential overflow scenarios.
Incident Report: Uneven Load Avalanche
·1342 words·7 mins
PostgreSQL PG Administration Incident Report
Recently there was a perplexing incident where a database had half its data volume and load migrated away, but ended up being overwhelmed due to increased load.