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

Mo J. Mughrabi
  • 195
  • 2
  • 7

2 Answers2

4

Replication between RDS and servers outside RDS is not currently supported by AWS.

See:

Community
  • 1
Craig Ringer
  • 10,553
  • 9
  • 38
  • 59
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

Nathan McFarland
  • 41
  • 2