Sample Header Ad - 728x90

PostgreSQL Continuous Archiving & Point-in-Time Recovery in combination with netbackup

0 votes
1 answer
541 views
I have the following setup: - OS: CentOS - PostgreSQL 12 - Netbackup 8 What I want to achieve: Configure continuous archiving with the possibility of Point-in-Time Recovery My current idea: 1. Generate a pg_basebackup every day at midnight and put the generated files in a folder outside of the data folder 2. Delete the files older than the created backup from the pg_wal folder 3. Create a Netbackup of the VM With these three steps I should be able to make a PITR every day starting from the last base backup until the upcoming base backup, and my pg_wal folder will never grow too much. Also the usage of the internal archiving is not required. Somehow this sounds very simple and I would like to ask if I am missing something here?
Asked by Florian Sauerwein (109 rep)
Mar 8, 2021, 03:01 PM
Last activity: Feb 1, 2025, 11:08 AM