pgBackRest PITR in Docker: a simple demo
While moving production database workloads towards cloud-native (Kubernetes) environments has become very popular lately, plenty of users still rely on good old Docker containers. Compared to running…
Фильтры
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,…
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…
Back from PGDay UK 2024
Last Wednesday (September 11, 2024), PGDay UK took place in London. Some of my colleagues live in the area (or not too far away), so it was…
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 PGConf Belgium 2024
Last Tuesday (May 7, 2024) happened PGConf.BE in Leuven, Belgium. Living in Belgium myself, going to tech conferences in my own country is always a little bit…