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:
- Generate a
pg_basebackupevery day at midnight and put the generated files in a folder outside of the data folder
- Delete the files older than the created backup from the
- 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?