Hi,
PostgreSQL master/slave Streaming replication is working fine .I also changed slave as master using trigger file.
I need some clarification on the below 2 scenarios:
1. once slave become master whatever the tables are created in new master it’s not replicated to old master, how to replicate the same from new master to old master
2. How to make old master as slave (which should accept read only transactions)
Can you please help me regarding this and also tell me is the above approach is valid or not.
I have tried 3 nodes(master/slave)—master(bring down master)/make it slave as master/and created new slave and it is working fine.
Thanks,
Anil.