Rackspace to RDS - PostgreSQL 9.2 Migration Plan
Rackspace to RDS - PostgreSQL 9.2 Migration Plan
От:
Patrick B <patrickbakerbr@gmail.com>
Дата:
Hi guys,
I've got a 2.3TB Database running at Rackspace... We'll be migrating it to RDS PostgreSQL 9.5 very soon...
... a EC2 Instance with full replica from prod (rackspace) has already been settled up at Amazon and it's working fine... (DMS will use that instance)...
As I've never used DMS, I just don't know how long it will take to migrate from EC2 Instance(Postgres 9.2) to RDS(Postgres 9.5)... can you guys give me some tips here? If anyone has used that would be great sharing the experience....
Also, will I have to migrate from Pgsql 9.2 to 9.3? Or I can to straight to 9.5?
Cheers
Patrick
Re: Rackspace to RDS - PostgreSQL 9.2 Migration Plan
От:
Guillaume Lelarge <guillaume@lelarge.info>
Дата:
Hi,
--
2016-08-30 4:26 GMT+02:00 Patrick B <patrickbakerbr@gmail.com>:
Hi guys,I've got a 2.3TB Database running at Rackspace... We'll be migrating it to RDS PostgreSQL 9.5 very soon...... a EC2 Instance with full replica from prod (rackspace) has already been settled up at Amazon and it's working fine... (DMS will use that instance)...As I've never used DMS, I just don't know how long it will take to migrate from EC2 Instance(Postgres 9.2) to RDS(Postgres 9.5)... can you guys give me some tips here? If anyone has used that would be great sharing the experience....
I don't know the answer for this but...
Also, will I have to migrate from Pgsql 9.2 to 9.3? Or I can to straight to 9.5?
This, I know :) You can go straight to 9.5.
--
Re: Rackspace to RDS - PostgreSQL 9.2 Migration Plan
От:
Magnus Hagander <magnus@hagander.net>
Дата:
On Tuesday, August 30, 2016, Guillaume Lelarge <guillaume@lelarge.info> wrote:
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
Hi,2016-08-30 4:26 GMT+02:00 Patrick B <patrickbakerbr@gmail.com>:Hi guys,I've got a 2.3TB Database running at Rackspace... We'll be migrating it to RDS PostgreSQL 9.5 very soon...... a EC2 Instance with full replica from prod (rackspace) has already been settled up at Amazon and it's working fine... (DMS will use that instance)...As I've never used DMS, I just don't know how long it will take to migrate from EC2 Instance(Postgres 9.2) to RDS(Postgres 9.5)... can you guys give me some tips here? If anyone has used that would be great sharing the experience....I don't know the answer for this but...Also, will I have to migrate from Pgsql 9.2 to 9.3? Or I can to straight to 9.5?This, I know :) You can go straight to 9.5.
IIRC the DMS doesn't actually support 9.2, it requires 9.4 or newer I believe. (You should double check that, my information might be old)
So you would have to start by upgrading your standalone cluster to 9.4 or 9.5 (PostgreSQL itself has no problem going directly to 9.5), and then use DMS to move it to RDS.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
Re: Rackspace to RDS - PostgreSQL 9.2 Migration Plan
От:
Patrick B <patrickbakerbr@gmail.com>
Дата:
IIRC the DMS doesn't actually support 9.2, it requires 9.4 or newer I believe. (You should double check that, my information might be old)So you would have to start by upgrading your standalone cluster to 9.4 or 9.5 (PostgreSQL itself has no problem going directly to 9.5), and then use DMS to move it to RDS.
Hmm.. interesting.. yep.. I've just seen that DMS requires Postgres 9.4 or above...
What about the time needed? Do you guys have any idea how long does it take?
Re: Rackspace to RDS - PostgreSQL 9.2 Migration Plan
От:
Jeff Frost <jeff@pgexperts.com>
Дата:
On Aug 30, 2016, at 2:51 PM, Patrick B <patrickbakerbr@gmail.com> wrote:IIRC the DMS doesn't actually support 9.2, it requires 9.4 or newer I believe. (You should double check that, my information might be old)So you would have to start by upgrading your standalone cluster to 9.4 or 9.5 (PostgreSQL itself has no problem going directly to 9.5), and then use DMS to move it to RDS.Hmm.. interesting.. yep.. I've just seen that DMS requires Postgres 9.4 or above...What about the time needed? Do you guys have any idea how long does it take?
I tried migrating a 300GB postgresql 9.4 cluster from Rackspace to RDS and it didn’t finish in 3 weeks, so we scrapped that plan and used Bucardo to migrate it which finished overnight.
Re: Rackspace to RDS - PostgreSQL 9.2 Migration Plan
От:
Patrick B <patrickbakerbr@gmail.com>
Дата:
I tried migrating a 300GB postgresql 9.4 cluster from Rackspace to RDS and it didn’t finish in 3 weeks, so we scrapped that plan and used Bucardo to migrate it which finished overnight.
OMG! 2TB will take years then... lol
=\