Because you’re on 9.6, you can’t use the native create subscription/publication
sql commands. I’d check out pglogical from 2nd quadrant; this should be
supported on RDS 9.6 iirc.
https://www.2ndquadrant.com/en/resources/pglogical/pglogical-docs/
That said, I’m a bit curious what security concer
I need to create a read-only replica in AWS environment. I can't use
AWS/RDS built-in read replica functionaility due to security concerns, so
I'm tied to using logical replication, on postgres 9.6. How do I configure
a replica db to receive the contents of the replication slot on master?
I was