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