Re: logical replication on 9.6: replica configuration

2019-05-12 Thread Jeremy Schneider
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

logical replication on 9.6: replica configuration

2019-05-12 Thread Paul Costello
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