- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
How to automate BART incremental backup
Any advice?
Kind regards,
Paul-Emmanuel Devadder
Archived Discussions
Effective March 31st, we will no longer engage on PostgresRocks.
How to engage with us further?
- Thought Leadership: EDB Blogs
- Tips and Tricks: Postgres Tutorials
- Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket
- Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: How to automate BART incremental backup
Hi @Polem ,
Please refer below prerequisites for taking the incremental backup :
1)Enable the allow_incremental_backups in the bart.cfg file
2)Password-less ssh between BART server and Master server if they are on different machine.
3)Do not enable the wal_compression parameter in bart.cfg
4)Archiving of the WAL must enabled to the BART backup catalog at <backup_path>/<server_name>/archived_wals.
Refer below steps to perform the incremental backup :
1) Take a full backup using the bart
bart BACKUP -s hr -F p --backup-name parent hr_full_1
2) Keep the bart-scanner running in background, so it will scan the wal files from archived_wals.
bart-scanner --daemon
3) Take a incremental backup
bart BACKUP -s hr -F p --parent hr_full_1 --backup-name hr_incr_1
4) Take another incremental backup
bart BACKUP -s hr -F p --parent hr_incr_1 --backup-name hr_incr_2
You can prepare a script for automating the above steps.
For detailed information, please refer document at : https://www.enterprisedb.com/docs/en/2.2/BART_Guide_2.2/EDB_Postgres_Backup_and_Recovery_Guide.1.14....
Please let us know in case of any issues/queries.
Regards,
Sudhir