This doesn't generate a unique id. You could back up a standby and restore it and point it at the original master and end up with two standbies with the same id.
On 08/22/2013 06:37 PM, Tom Lane wrote: > A > Do we have a reliable way of generating a unique identifier for each slave > (independently of how that might be exposed)?
Probably we could just generate an unique UUID when we first detect that we are replicating from the master with same UUID.
This of course requires this master UUID to be present in some way in the replication stream
Cheers -- Hannu Krosing PostgreSQL Consultant Performance, Scalability and High Availability 2ndQuadrant Nordic OÜ
