How can I reduce the frequency of automated snapshots in Amazon RDS PostgreSQL?

0

We have a RDS - PostgreSQL db. Auto snapshots are taken every day. Would like to change the frequency to once every week. I did not see a way to do it. Looks like I can only control the backup retention period but not the snapshot frequency. Is there a way for me to do that? Please let me know.

Thank you!!

Indu
demandé il y a 6 mois380 vues
2 réponses
1

Hello.

As you know, RDS automatic backups are done daily.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html

Automated backups occur daily during the preferred backup window. If the backup requires more time than allotted to the backup window, the backup continues after the window ends until it finishes. The backup window can't overlap with the weekly maintenance window for the DB instance or Multi-AZ DB cluster.

Therefore, if you manage RDS backups with AWS Backup, you will be able to change the backup frequency.
As mentioned in the documentation below, when point-in-time recovery is enabled, it is retrieved daily, so I thought I could disable it and configure it to adjust the backup frequency.
https://docs.aws.amazon.com/aws-backup/latest/devguide/point-in-time-recovery.html

You can perform a point-in-time recovery using either AWS Backup or Amazon RDS. For AWS Backup console instructions, see Restoring an Amazon RDS Database. For Amazon RDS instructions, see Restoring a DB Instance to a specified time in the Amazon RDS User Guide. RDS takes snapshots once per day regardless if a backup plan has a frequency for snapshot backups other than once per day.

profile picture
EXPERT
répondu il y a 6 mois
profile pictureAWS
EXPERT
vérifié il y a 6 mois
0

Greetings, RDS backups are done automatically daily. As Riku^ Mentioned, you can change the frequency.

AWS
EXPERT
ZJon
répondu il y a 6 mois
  • you can change the frequency of the backups?

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions