scheduling bart backups,

SOLVED
Highlighted
Silver Adventurer

scheduling bart backups,

looking for best practices for scheduling bart backups.

 

matt

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Moderator

Re: scheduling bart backups,

Hi Matt,

Hope you are doing good !

Scheduling of the backup job depends on the recovery objective and the retention policy which we are going to follow for the backup. Retention_policy determines when an active backup should be marked as obsolete, and hence, be a candidate for deletion.

The setting can be either max_number BACKUPS, max_number DAYS, max_number WEEKS, or max_number MONTHS where max_number is a positive integer. If all of the keywords BACKUPS, DAYS, WEEKS, and MONTHS are omitted, the specified integer is interpreted as max_number BACKUPS by default.

The setting of the retention_policy parameter in the server section of the BART configuration file overrides the setting of retention_policy in the global section for that particular database server. If omitted in the server section, the setting of retention_policy in the global section is used. If the retention_policy parameter is not specified in either section, then no additional backups are marked as obsolete when the MANAGE subcommand is used.

Once the retention policies have been determined and verified, you can create a cron job to periodically run the MANAGE subcommand to evaluate the backups and then list and/or delete the obsolete backups.

Please check the below link for managing the backup's,

https://www.enterprisedb.com/docs/en/2.0/bart/EDB_Postgres_Backup_and_Recovery_Guide.1.17.html

I have also attached EnterpriseDB's best practice guide for more information backup and recovery.

View solution in original post

Highlighted
Silver Adventurer

Re: scheduling bart backups,

2 REPLIES 2
Highlighted
Moderator

Re: scheduling bart backups,

Hi Matt,

Hope you are doing good !

Scheduling of the backup job depends on the recovery objective and the retention policy which we are going to follow for the backup. Retention_policy determines when an active backup should be marked as obsolete, and hence, be a candidate for deletion.

The setting can be either max_number BACKUPS, max_number DAYS, max_number WEEKS, or max_number MONTHS where max_number is a positive integer. If all of the keywords BACKUPS, DAYS, WEEKS, and MONTHS are omitted, the specified integer is interpreted as max_number BACKUPS by default.

The setting of the retention_policy parameter in the server section of the BART configuration file overrides the setting of retention_policy in the global section for that particular database server. If omitted in the server section, the setting of retention_policy in the global section is used. If the retention_policy parameter is not specified in either section, then no additional backups are marked as obsolete when the MANAGE subcommand is used.

Once the retention policies have been determined and verified, you can create a cron job to periodically run the MANAGE subcommand to evaluate the backups and then list and/or delete the obsolete backups.

Please check the below link for managing the backup's,

https://www.enterprisedb.com/docs/en/2.0/bart/EDB_Postgres_Backup_and_Recovery_Guide.1.17.html

I have also attached EnterpriseDB's best practice guide for more information backup and recovery.

View solution in original post

Highlighted
Silver Adventurer

Re: scheduling bart backups,

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks