How to Use pg_filedump for Data Recovery?
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!
Machine restarted due to failure, NTP service corrected PG time after PG startup, causing Patroni to fail to start.
Today encountered an interesting case where a customer reported database connection issues caused by extensions.
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.
Using binary editing to repair PostgreSQL data pages, and how to make a primary key query return two records.
If you use Integer sequences on tables, you should consider potential overflow scenarios.
XID WrapAround is perhaps a unique type of failure specific to 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.