Merging RDS and Aurora postgres

0

I have an RDS PostgresSql database and an aurora postgres database set up currently and am trying to weigh how to merge them together.

For background info they are two different databases currently as they have different tables/schemas and are somewhat unrelated but ideally they would be in the same aurora database as the upkeep of the two databases is getting pretty annoying and logically the data is very similar. I am not entirely against leaving the two databases as is but I am doing due diligence and would prefer to merge ideally. All solutions I have seen generally deal with straight conversion to a new aurora instead of merging with an existing aurora database.

The RDS databse is currently postgres 11 and the aurora is postgres 13.8. Is there any clean way to combine these two into one aurora database? Or am I left to manually transfer the data somehow

1개 답변
0

You have 2 options which I’ve carried out.

  1. Use AWS DMS to migrate the database over to Aurora.
  2. muse native pgdump to export and import the database from once instance to the other.
profile picture
전문가
답변함 7달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인