Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Is it safe to change the password of a PostgreSQL read replica on AWS RDS?

Tags:

postgresql

amazon-web-services

amazon-rds

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).

like image 317
Olivier Lalonde Avatar asked May 27 '16 21:05

Olivier Lalonde

People also ask

Are Read replicas encrypted?

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.

Which of the below statements are true about Amazon RDS Read replica?

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.

How many Read replicas can you have from one master instance?

Amazon RDS for MySQL, MariaDB, PostgreSQL, Oracle, and SQL Server allow you to add up to 5 read replicas to each DB Instance.

1 Answers

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.

like image 83
Eric Yang Avatar answered Sep 22 '22 17:09

Eric Yang
Sign in to Comment

Related questions

Postgres truncate restart identity doesn't restart identity
Order by using month name in PostgreSQL
.pgpass for PostgreSQL replication in Dockerized environment
PostgreSQL: get count of occurrences of specified element in array
AWS Deployment with Rails - configuration file in .ebextensions
FATAL: role "root" does not exist
Whitespace in returned query with Python and py-postgresql
Why does this PostgreSQL transaction give "WARNING: there is no transaction in progress"
how to import in format CSV chars as ñ, Ã in PostgreSQL
docker-compose does not start postgres image
Are postgresql transaction levels repeatable read and serializable the same?
How do I trigger or call a function on INSERT to one table based on result of another table?
How do I query with JSON function/operator where key is either not null or is null?
Get this result back when putting `postgres -D /usr/local/var/postgres` in terminal
entry cannot be referenced in this part of the query (subquery) Error
ActiveRecord query, order by association, last of has_many
panic: sql: expected 1 destination arguments in Scan, not <number> golang, pq, sql
select all duplicates from a table in postgres
PostgreSQL - making ts_rank take the ts_vector position as-is or defining a custom ts_rank function
Why I am getting error: An operation is already in progress

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!