cancel
Showing results for 
Search instead for 
Did you mean: 

scheduling bart backups,

SOLVED
Highlighted
Level 2 Adventurer

scheduling bart backups,

looking for best practices for scheduling bart backups.

 

matt

2 ACCEPTED SOLUTIONS

Accepted Solutions
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.

Level 2 Adventurer

Re: scheduling bart backups,

thanks'

2 REPLIES
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.

Level 2 Adventurer

Re: scheduling bart backups,

thanks'