if we configure PostgreSQL for synchronous replication with multiple standby servers. When failover happens, how temporal passive cluster knows to connect to which PosgreSQL server? Is there any configuration for this? Thanks.
The multi-cluster replication feature doesn’t rely on DB failover. Each cluster uses a completely independent database instance. DBs can even be of different types, like Cassandra and PostgreSQL.