logical replication on 9.6: replica configuration

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

logical replication on 9.6: replica configuration

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 able to get logical replication going with the following 2 commands:

SELECT pg_create_logical_replication_slot('test_slot', 'test_decoding');
pg_recvlogical -d test --slot test_slot --start -f - &

I'm very unclear on where to go from there to stand up a read-replica db.

Thanks,
Paul C.

jer
Reply | Threaded
Open this post in threaded view
|

Re: logical replication on 9.6: replica configuration

jer
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.


That said, I’m a bit curious what security concern would disallow a physical hot standby and allow a logical replication setup - especially in a managed environment... are you able to share any more specifics about the reasoning here? Maybe the requirement is for the replica to be in a different account or something?

-Jeremy


Sent from my TI-83

On May 12, 2019, at 20:51, Paul Costello <[hidden email]> wrote:

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 able to get logical replication going with the following 2 commands:

SELECT pg_create_logical_replication_slot('test_slot', 'test_decoding');
pg_recvlogical -d test --slot test_slot --start -f - &

I'm very unclear on where to go from there to stand up a read-replica db.

Thanks,
Paul C.