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

5
votes

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

1
postgresqlamazon-web-servicesamazon-rds
Did you ever find the answer to this question? – Eric Yang
I don't believe I did! – Olivier Lalonde
Contacted support and they told me no, unfortunately. – Eric Yang

1 Answers

9
votes

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.