Trying to copy a postgres instance from a local postgres server to an RDS instance via DMS

0

Greetings, thanks for looking at my question.

I've followed this AWS documentation and set up a VPC, created a replication instance on DMS and set up the database server (it's on an EC2 instance currently, but ultimately we will be using a local server running postgres and the production database from our rack as the source) as the source endpoint and the RDS instance as the target endpoint. I'm trying to set up streaming replication, however, so the information on logical replication and CDC isn't relevant to my setup.

The goal is to have our production database instance backed up and replicating to an RDS instance, down the road we hope to spin up EC2s and connect them to this RDS instance to scale up as needed. For now though we are just trying to get it set up for proof of concept.

So I've done everything advised in the docs, but need to copy the database to the RDS instance and start the replication. I created a Database Migration Task in DMS (Full load, ongoing replication), but it fails and doesn't copy over the database or tables.

This is the error message on the AWS DMS dashboard for the Migration Task:

Last Error Task 'FB24Y2N4*****************************HLB4R3Q' was suspended after 9 successive recovery failures Stop Reason FATAL_ERROR Error Level FATAL

Grateful for any advice from anyone who has successfuly set up a similar architecture. Thanks.


Edit to clarify: The problem isn't the error per se, it's that I need to find out why the DMS migration task that I created isn't initially copying the instance from my EC2 Postgres source to my AWS RDS instance endpoint and then beginning and maintaining replication. How do I get my database that I'm trying to replicate on RDS copied over?

1개 답변
0

Hello,

Sorry to hear that you are facing issue with the same. The maximum number of attempts made to restart a task when an environmental error occurs. After the system attempts to restart the task the designated number of times, the task is stopped and manual intervention is required. The default value is -1, which instructs AWS DMS to attempt to restart the task indefinitely. Set this value to 0 to never attempt to restart a task. If a fatal error occurs, AWS DMS stops attempting to restart the task after six attempts.

Refer this link for Trouble-shooting steps= https://aws.amazon.com/blogs/database/debugging-your-aws-dms-migrations-what-to-do-when-things-go-wrong-part-1/

profile pictureAWS
지원 엔지니어
답변함 2년 전
  • The problem isn't the error per se, it's that I need to find out why the DMS migration task that I created isn't initially copying the instance from my EC2 Postgres source to my AWS RDS instance endpoint and then beginning and maintaining replication. How do I get my database that I'm trying to replicate on RDS copied over?

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

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

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

관련 콘텐츠