PostgreSQL replication to Amazon RDS
amazon-rds, amazon-web-services, database-replication, postgresql
Solution
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
Problem
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?