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,300 points
122 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
+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,140 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,140 points
227 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,250 points
1,521 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.