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?