PostgreSQL replication to Amazon RDS

Question

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?

Answer 1

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