PostgreSQL and Disaster Recovery Strategy – part 3

Taking physical backups with pgbackrest Besides logical backup, with PostgreSQL, we can take physical backups. Physical backups are copies of the PostgreSQL cluster files. There are three ways to get physical backups that are consistent: Stop PostgreSQL in the server and copy all data files. Use built in tool pg_basebackup. Use third party tool that… Continue reading PostgreSQL and Disaster Recovery Strategy – part 3

PostgreSQL and Disaster Recovery Strategy – part 2

In the second part of this series, we will consider the different ways you can take backup and how they can fit into a disaster recovery strategy. There are three ways you can take backups: Logical backups (pg_dump and pg_dumpall) Physical backups (pg_basebackup, wal-e, pgbackrest) Archiving (copying wal files before they are deleted) Let’s consider… Continue reading PostgreSQL and Disaster Recovery Strategy – part 2

PostgreSQL and Disaster Recovery Strategy – part 1

Introduction We all wish to have a magical button in our system that recovers everything in case of disaster. Sadly, it is not that easy. Many companies get stuck in doing backup strategies, but do they have a disaster recovery strategy? There is a vast difference between both. In a backup strategy you only plan… Continue reading PostgreSQL and Disaster Recovery Strategy – part 1

%d bloggers like this: