Skip to content

RDS data consistency across accounts and Min AWS Backup frequency

0
  1. Is there any way to achieve near realtime (potentially no data loss) sync/replication of RDS Postgres between 2 aws accounts in the same region but different AZ?
  2. What is the minimum backup frequency that can be set in AWS Backup for resources such as RDS, EFS, etc?

asked 2 years ago214 views

2 Answers
1

Hello.

I think it is possible to easily replicate RDS PostgreSQL across accounts using AWS DMS.
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html

I think the minimum backup frequency for AWS Backup can be set to one hour.
https://docs.aws.amazon.com/aws-backup/latest/devguide/plan-options-and-configuration.html

The backup frequency determines how often AWS Backup creates a snapshot backup. Using the console, you can choose a frequency of every hour, 12 hours, daily, weekly, or monthly. You can also create a cron expression that creates snapshot backups as frequently as hourly. Using the AWS Backup CLI, you can schedule snapshot backups as frequently as hourly.

EXPERT

answered 2 years ago

0

There is no way to achieve synchronous replication between two accounts, but you can setup your own replication with pg_active to setup a self managed asynchronous replication.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.pgactive.html

AWS
MODERATOR

answered 2 years ago

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.