cancel
Showing results for 
Search instead for 
Did you mean: 

Can we use xDB replication on Amazon RDS?

Highlighted
Adventurer

Can we use xDB replication on Amazon RDS?

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

>> etc.

 

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?

 

We have:

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.

 

Thanks.

 

 

1 REPLY
EDB Team Member

Re: Can we use xDB replication on Amazon RDS?

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