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?

postgresqlamazon-web-servicesdatabase-replicationamazon-rds

Reputation: 647

PostgreSQL replication to Amazon RDS

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?

Upvotes: 9

Answers (2)

michel-lind

Reputation: 9766

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

Upvotes: 6

slayedbylucifer

Reputation: 23512

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

Upvotes: 1

PostgreSQL replication to Amazon RDS

Answers (2)

Related Questions