Open xytxyt opened 9 months ago
I have never used pglogical for BDR, but when I use it for postgres major version upgrades, usually the topology looks like:
So the answer to the question of whether you can have a hot standby replicating physically from a pglogical subscriber is: yes.
1: I have two main sever in different geolocation which is using pglogical for bi-directional replications 2: I want to have a full stream physical replica on each main server's location as hotstandby. Can I still use the postgresql's built in physical replica method to do so? Or is it necessary.
I tried to do it, but somehow I did not manage to see the data in the replica postgres. So want to get some ideas/confidence to check before I dig into it.
Thanks in advance.