Re: server auto-restarts and ipcs - Mailing list pgsql-general

From Tom Lane
Subject Re: server auto-restarts and ipcs
Date
Msg-id 5353.1100036177@sss.pgh.pa.us
Whole thread Raw
In response to Re: server auto-restarts and ipcs  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Greg Stark <gsstark@MIT.EDU> writes:
> Oh I missed the fact that you were talking about after a reboot. So the
> algorithm I described would produce exactly the same sequence of ids after any
> reboot given the same sequence of creation and deletions. Even if there's a
> different sequence as long as the n'th creation is for the m'th array slot it
> would get the same id. So collisions would be very common.

This seems to square with Ed's complaint that he frequently sees a
collision after a reboot.  I've just committed some code that makes a
more extensive check as to whether a pre-existing segment actually has
any relevance to our data directory; should fix the problem.

            regards, tom lane

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: [pgsql-www] FTP mirror problems
Next
From: Tom Lane
Date:
Subject: Re: Creating DB with pass, but pass not required to connect