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 Fri, Aug 23, 2013 at 4:08 PM, Hannu Krosing <ha...@2ndquadrant.com>wrote: > 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Ü > > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- greg
