Skip to content
Home » Archives for November 2023

November 2023

Understanding Incremental Data Backup in pg_rman

Previously, we discussed how to perform a simple backup using pg_rman. As pg_rman can back up PostgreSQL at the physical file copy level, it is quite useful for daily database maintenance. Particularly, pg_rman supports incremental backup, which only backs up the changed data. In this blog, I will explain how incremental backup works in pg_rman. Firstly, all of this relies on the table and index page layout implemented in PostgreSQL. In PostgreSQL, each data page is laid out like this. The pageHeaderData has many attributes, and one of the most important attributes is pd_lsn, which is updated to the last… Read More »Understanding Incremental Data Backup in pg_rman