Recommendations for migrating PG 9.3 RDS across regions

From: Joshua Ma <josh(at)benchling(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Recommendations for migrating PG 9.3 RDS across regions
Date: 2015-10-17 22:24:26
Message-ID: CAG9XPVkc8+8WM0ZAJb35N5ODeOM9sYvMDmVQEmZCp=hSuys6EA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Mead 2015-10-18 01:00:51 Re: ID column naming convention
Previous Message Francisco Olarte 2015-10-17 11:42:06 Re: question