Tags: Incident-Report
How to Use pg_filedump for Data Recovery?
September 27, 2023 in PostgreSQL
Backups are a DBA's lifeline — but what if your PostgreSQL database has already exploded and you have no backups? Maybe `pg_filedump` can help you!
Backups are a DBA's lifeline — but what if your PostgreSQL database has already exploded and you have no backups? Maybe `pg_filedump` can help you!
Incident-Report: Patroni Failure Due to Time Travel
February 22, 2021 in PostgreSQL
Machine restarted due to failure, NTP service corrected PG time after PG startup, causing Patroni to fail to start.
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
June 13, 2019 in PostgreSQL
Today encountered an interesting case where a customer reported database connection issues caused by extensions.
Today encountered an interesting case where a customer reported database connection issues caused by extensions.
Incident-Report: Connection-Pool Contamination Caused by pg_dump
December 11, 2018 in PostgreSQL
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.
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
November 29, 2018 in PostgreSQL
Using binary editing to repair PostgreSQL data pages, and how to make a primary key query return two records.
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
July 20, 2018 in PostgreSQL
XID WrapAround is perhaps a unique type of failure specific to PostgreSQL
XID WrapAround is perhaps a unique type of failure specific to PostgreSQL
Incident-Report: Integer Overflow from Rapid Sequence Number Consumption
July 20, 2018 in PostgreSQL
If you use Integer sequences on tables, you should consider potential overflow scenarios.
If you use Integer sequences on tables, you should consider potential overflow scenarios.
Incident-Report: Uneven Load Avalanche
April 08, 2018 in PostgreSQL
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.
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.