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.