Sun.Jul 02, 2023

article thumbnail

Exploring PostgreSQL Backup Strategies for Enterprise-Grade Environments

Percona

This blog was originally written in September 2018 and was updated in June 2023. In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster. In setting up our demonstration system, we use pg_basebackup and continuous archiving. The size of the database and your database environment—if it is on colo or cloud—matters.