I have a postgresql setup with 1 master and 3 slaves. Now I want to setup a replication for only one database to reporting server.
My problem statements:
- I can't use bucardo (no approval for creating triggers on prod tables)
- pglogical only works on Master node.(the publisher).
- I want to replicate from slave (this is my end goal)