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]
The replication between pg master and pg slave was set as "hot_standby" mode.
I try to daisy chain (or cascade replication in postgresql term) connection on pg slave due to performance and high availability concerns.
From pg slave on-prem to aws replication instance, as AWS documentation suggested, that I have to set the replication mode as "logical".
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.