Re: Replication Node Identifiers and crashsafe Apply Progress - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Replication Node Identifiers and crashsafe Apply Progress
Date
Msg-id 528E8348.8060203@gmx.net
Whole thread Raw
In response to Re: Replication Node Identifiers and crashsafe Apply Progress  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On 11/21/13, 6:15 AM, Andres Freund wrote:
> On 2013-11-20 15:05:17 -0500, Robert Haas wrote:
>>> That's what I had suggested to some people originally and the response
>>> was, well, somewhat unenthusiastic. It's not that easy to assign them in
>>> a meaningful automated manner. How do you automatically assign a pg
>>> cluster an id?
>>
>> /dev/urandom
> 
> Well yes. But then you need a way to store and change that random id for
> each cluster.

You can use a v3 UUID, which is globally reproducible.




pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [PATCH] Use MAP_HUGETLB where supported (v3)
Next
From: Peter Eisentraut
Date:
Subject: Re: Re: [BUGS] BUG #7873: pg_restore --clean tries to drop tables that don't exist