Tag: backup
Remote Backup and Restore with pgBackRest
In my previous post about pgBackRest, we saw how to install and setup pgBackRest and make a backup of a PostgreSQL database with it. It was a very basic single server setup, only intended to get the hang of the tool. Such setups are not used in a production environment, as it is not recommended […]
pgBackRest to Backup PostgreSQL
pgBackRest is an open source backup tool for PostgreSQL which offers easy configuration and reliable backups. So if you want to protect your database and create backups easily, pgBackRest is a good solution to make that happen. In this blog, we are going to go through the basic steps of using pgBackRest for full and […]
“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 […]