9

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?

Improve this question
1

2 Answers 2

Reset to default
6

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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

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

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.