Migration on-premise Postgresql into AWS RDS

0 votes

I work on migration on-premise postgresql 9.5 server into RDS. Basically the chain I have come out look like this:

[pg master on-premise] -> [pg slave on-premise] -> [aws dms replication instance] -> [aws rds postgresql]

Note that:

  1. The replication between pg master and pg slave was set as "hot_standby" mode.

  2. I try to daisy chain (or cascade replication in postgresql term) connection on pg slave due to performance and high availability concerns.

  3. From pg slave on-prem to aws replication instance, as AWS documentation suggested, that I have to set the replication mode as "logical".

  4. Changing all replication mode to "logical" should be the last consideration.

Just wonder if this kind of half-half (half-hotstandby-half-logical) would work. If that works, what kind of stuffs I need to pay special attention with. And, if that won't work, what alternative ways you would suggest.

Thanks a lot.

Aug 24, 2018 in AWS by bug_seeker
• 15,310 points
140 views

1 answer to this question.

+1 vote

Actually the solution purposed works. But there's a spin-off issue: either my data have problem in the middle of the journey, or DMS does not support jsonb format

answered Aug 24, 2018 by Priyaj
• 56,160 points

Related Questions In AWS

0 votes
1 answer
0 votes
1 answer

Notification to AWS SNS to insert a record insert into Mysql Rds table?

You can achieve "automatic" triggering by AWS Lambda or ...READ MORE

answered Oct 31, 2018 in AWS by Priyaj
• 56,160 points
250 views
+1 vote
2 answers

How do I run python script on aws EC2 instance(ubuntu)?

I believe that you are using the ...READ MORE

answered Apr 17, 2018 in AWS by Cloud gunner
• 4,260 points
1,626 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Getting memory leak error on AWS EMR - Saving Dataframe into hive external table on S3 -

You can start by creating  a temp ...READ MORE

answered Aug 9, 2018 in AWS by Priyaj
• 56,160 points
109 views