Geo: Database replication in the secondary cluster
UPDATE We've consolidated the work necessary to support high-availability PostgreSQL using Patroni in &2536 (closed). I am closing this to remove duplication.
A large customer is wanting to set up database replication in their secondary cluster.
Currently, we do not support database replication in the secondary cluster. They wish to have database replication working to try and mirror their production setup.
Some initial thoughts are to use another replication slot on the primary database and let this node sync directly from the primary. As far as I am aware, it is not possible to set up replication from a hot_standby PostgreSQL node.
Is there a better way to accomplish database replication in the secondary cluster?
Links / references
Customer ticket: https://gitlab.zendesk.com/agent/tickets/113919 https://gitlab.my.salesforce.com/0016100000KvaIg?srPos=0&srKp=001 (internal use)