“Exclusive backup” method is deprecated – what now?
UPDATE 12.07.2022: The “exclusive backup” method of calling pg_start_backup(‘label’) before backup and pg_stop_backup() afterwards has been removed in PostgreSQL v15. This article describes the problems with the old method and discusses the options for those who still use this backup method. I include scripts below to help you. The “exclusive” backup method Before pg_basebackup was […]
pg_basebackup: Creating self-sufficient backups
If you are using transaction log shipping (or Point-In-Time-Recovery) in PostgreSQL to keep your data safe, you will surely already know about pg_basebackup. The idea behind pg_basebackup is to allow users to create a binary copy of the data, which can serve as the basis for Point-In-Time-Recovery. However, recently we have seen some support cases, […]
Managing backup speed
In the past couple of years replication has been made easier and easier. Setting up streaming replication is pretty easy these days. When doing training I am getting a lot of positive feedback and people seem to like the way entire database instances can be cloned. In many cases DBAs use a straightforward approach to […]