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
Last activity: Feb 1, 2025, 11:08 AM