Geek Answers Handbook

PostgreSQL Replication for Amazon RDS

Amazon recently introduced PostgreSQL support for its Amazon RDS service. I was wondering if this scenario is possible:

  • Setting up a PostgreSQL instance on Amazon RDS
  • Install PostgreSQL on my VPS
  • Installation replication so that any changes I make to the database in my VPS are automatically reflected on the PostgreSQL instance on Amazon RDS

Is it possible? If so, what would be the steps to achieve it?

+7
postgresql amazon-web-services amazon-rds database-replication
source share
2 answers

Replication using trigger systems such as Londiste and Bucardo to and from RDS is now supported since November 10, 2014 , for responding to this forum.

Announcement here

+5
source share

I think that this is impossible. SImilar functionality is available for MySQL RDS: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html

However, the closest I could find to PostgreSQL RDS is: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL.Procedural.Importing.html

Check out the AWS forum to better think about it: https://forums.aws.amazon.com/index.jspa

+1
source share

More articles:


All Articles