Hi guys need help, I have no idea yet on Postgres RDS on how to replicate its data going to non-rds Postgres (EC2 or On premise Postgres),
We are looking for some possible solutions:
>> Trigger Based replication
>> Logical Replication
>> PEM server (Streaming Replication)
>> xdb Replication
Right now, we are planning to setup a replication using xDB replication Server of EDB, is it possible , or use case using xdb replication in Postgres Amazon RDS?
Postgres RDS (master) going to EC2 Postgres (Slave), or
Postgres RDS (master) going to a Postgres hosted in on baremetal server with tools like PEM, xdb Replication Server.
RDS will not let you install any third party software. According to AWS documentation ( http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html)
"In order to deliver a managed service experience, Amazon RDS does not provide host access to DB instances, and it restricts access to certain system procedures and tables that require advanced privileges."
Because of this xDB cannot be installed/used