I'm currently looking into how we might migrate an AWS-hosted database (via RDS) from us-west-2 to us-east-1. This isn't natively supported by RDS right now, so I was wondering if anyone has had success with 3rd-party tools. (I'm also on 9.3, unfortunately, so I lack some of 9.4's replication features.)
I can always do a pg_dump and pg_restore, but ideally we do some sort of streaming replication to minimize downtime. Ideally, we'd set up replication, turn off writes to the primary, promote the replica, flip DNS, and resume with newly promoted replica as primary. The DB we're migrating is ~100GB in size - not too huge, but large enough for pg_dump to take awhile. For starters, will I run into issues with Londiste, Slony, or Bucardo, since RDS has more restricted permissions? Is one of Londiste, Slony, or Bucardo obviously better than the others for this task? At first glance Bucardo seems the most straightforward, but that may just be due to the docs being easier to glance through. (I've also never used any postgres replication outside of the native replication, so it's possible that some of these tools aren't applicable...) Any tips/links would be much appreciated. Best, Josh ᐧ
