pgBackRest preview: verify recovery target timeline on restore
Have you ever faced timeline issues during PostgreSQL recovery? It can be frustrating to complete a restore only to discover during recovery that the timeline is invalid,…
Filter
Avoiding the WAL Archives Retention Trap in pgBackRest
While answering support issues on pgBackRest, I regularly see some users falling in the infinite archives retention trap and asking the same question: Why are my old…
From Backup to Integrity: Leveraging WAL-G for PostgreSQL
A key aspect of maintaining backup integrity is understanding data checksums. Without proper checksum validation, detecting data corruption becomes virtually impossible. Therefore, we will start with The…
PITR and Streaming Replication environments
Recently, I had to address a support case where a user was struggling to perform Point-in-Time Recovery in his PostgreSQL cluster using streaming replication. We have already…
Back from FOSDEM 2024
Everyone knows FOSDEM, right? The PostgreSQL Project has been present there with a booth and a Devroom since more than 15 years now! And this year there…
Automated index bloat management: How pg_index_watch keeps PostgreSQL indexes lean.
To follow up on my introductory blog post, here is a more extensive deep dive into ins and outs of pg_index_watch. In this post, I will take…