Automate RDS (PostgreSQL) snapshot to another region
Hi Support, We are at our limit of replicated snapshots to a specific region (Oregon, us-west-2). Is there a way to automatically create a snapshot and automatically copy it to that same region?
I came across a similar question: https://repost.aws/questions/QUeIHpRR12QhepU1NiMicp_g/automate-snapshot-copy-across-region but reading the answer given, is not clear to me if this is possible or how.
Thank you for your time and help. Best Regards, Donald
- 주제
- 데이터베이스
- 언어
- English
- 최신
- 최다 투표
- 가장 많은 댓글
Hi Support, in reading the provided link (https://dev.to/aws-builders/aws-event-bridge-and-lambda-to-copy-rds-snapshots-to-another-region-kl3) , I came across this: | AWS Documentation says: "You can have up to 20 snapshot copy requests in progress to a single destination Region per account." | We already have (20) replications going to Oregon. So are we at our limit for snapshot copy requests too for the Oregon region ? IE, we can't send anything else to Oregon region b/c we are at our (20) limit...
Thank you for your time and help! Best Regards, Donald
Hello,
If you want to disable automated snapshots in RDS to be replicated to (Oregon, us-west-2). You can follow these steps: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReplicateBackups.html#AutomatedBackups.StopReplicating
This will ensure that automated snapshot feature is still enabled and be stored in the same region as the RDS instance but no longer copied to your specified region(Oregon, us-west-2).
I hope this the solution you're looking, Right? If you're using AWS Backup to replicate snapshots then it's a different way on how to do it.
Hi! We don't want to disable automated snapshots or replication. I just want to automate copying the existing snapshots to Oregon.
Also, just saw this reply from Sivaraman (thank you!) and will review link.... " Here's an example to automate copy snapshots to destination region using Amazon Event bridge and Lambda: https://dev.to/aws-builders/aws-event-bridge-and-lambda-to-copy-rds-snapshots-to-another-region-kl3 "
Hello.
Cross-region snapshot copying within the same AWS account is possible by configuring AWS Backup.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RDS_Fea_Regions_DB-eng.Feature.CrossRegionAutomatedBackups.html
https://docs.aws.amazon.com/aws-backup/latest/devguide/cross-region-backup.html#scheduled-crb
Thank you for your quick reply! We have AWS backup and snapshots in place, I'd show the screenshot of these backups but I don't see how to attach or place the screenshot here.. "Backup Automated backups Enabled (30 Days) Copy tags to snapshots Disabled Backup target AWS Cloud (US East (Ohio)) "
How do we automate copying these snapshots to another region without using replication?
Here's an example to automate copy snapshots to destination region using Amazon Event bridge and Lambda: https://dev.to/aws-builders/aws-event-bridge-and-lambda-to-copy-rds-snapshots-to-another-region-kl3
이 게시물은 마감됨: 새 답변, 댓글 및 투표 추가가 비활성화되었습니다.
관련 콘텐츠
- 질문됨 일 년 전
This is the way to accomplish what we would like to do! " Here's an example to automate copy snapshots to destination region using Amazon Event bridge and Lambda: https://dev.to/aws-builders/aws-event-bridge-and-lambda-to-copy-rds-snapshots-to-another-region-kl3 " Thank you to Sivaraman Selvam ! https://repost.aws/community/users/USQVAmFo42SEiE9N9qqYRPyg