Menu
Is it safe to change the password of a PostgreSQL read replica on AWS RDS? I would like to use the read replica to download database snapshots on my laptop but don't want to have the master database password there.
It currently has the same password as the master database and I only use it for offline analytics (e.g. nothing important uses it).
317
A read replica of an Amazon RDS encrypted instance must be encrypted using the same KMS key as the primary DB instance when both are in the same AWS Region. If the primary DB instance and read replica are in different AWS Regions, you encrypt the read replica using the KMS key for that AWS Region.
1 Answer. The correct options are option (B) and option (C). RDS DB instances can be deployed to the virtual private cloud is correct. Also, RDS allows us to backup and restore to any point of DB instance.
Amazon RDS for MySQL, MariaDB, PostgreSQL, Oracle, and SQL Server allow you to add up to 5 read replicas to each DB Instance.
I contacted AWS support, and after a lengthy exchange the answer is no: you must use the same password for postgres master/slave DBs. The support rep hinted that it may be possible with other DB types, though.
83
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
