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
asked 5 months ago347 views
2 Answers
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
answered 5 months ago
profile pictureAWS
EXPERT
reviewed 5 months ago
0

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

AWS
EXPERT
ZJon
answered 5 months ago
  • you can change the frequency of the backups?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions