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,520 points
1,626 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
• 58,100 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
• 58,100 points
3,368 views
+3 votes
4 answers

How to host a website on AWS?

Certainly, it can be used to do ...READ MORE

answered Mar 30, 2018 in AWS by brat_1
• 7,200 points
2,882 views
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
• 58,100 points
1,461 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP