PostgreSQL replication to Amazon RDS

8
votes

Amazon recently introduced PostgreSQL support for their Amazon RDS service. I was wondering if this scenario could be possible:

  • Setup a PostgreSQL instance on Amazon RDS
  • Install PostgreSQL on my VPS
  • Setup replication so that any changes I make on the DB in my VPS are automatically mirrored on the PostgreSQL instance on Amazon RDS

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

2
postgresqlamazon-web-servicesdatabase-replicationamazon-rds
See serverfault.com/q/605460/102814, dba.stackexchange.com/q/61305/7788, dba.stackexchange.com/q/66372/7788, forums.aws.amazon.com/message.jspa?messageID=547192#547192 – Craig Ringer

2 Answers

6
votes

Replication using trigger-based systems like Londiste and Bucardo into and out of RDS is now supported as of Nov. 10th 2014, per a reply on that forum thread.

Announcement here

1
votes

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

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

Check on AWS Forum for better thoughts around this: https://forums.aws.amazon.com/index.jspa