3

we currently are using amazon Postgresql 9.3 RDS as a master database for a gaming platform. We would like to create a read only replication to use for reporting and heavy queries.

Yes, it seems like "read replica" option in amazon RDS is not active for postgresql databases.

Would it be possible to create a read replica using EC2 instance with postgresql server, taking into consideration we cannot edit pg_hba.conf among other files in the master database since its running on RDS? we can only edit postgres.conf parameters

can any one advise on what would be best way to go on with it? thanks

4

This has just changed and Read Replication is supported both internally to RDS, and via triggers to external databases. The forum announcement is here: https://forums.aws.amazon.com/ann.jspa?annID=2747

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.