Re: server auto-restarts and ipcs

On Tuesday November 9 2004 4:35, Tom Lane wrote:
> "Ed L." <pgsql@bluepolka.net> writes:
> > I noticed that ipcs on my linux box has a command-line option to list
> > the pid that created the segment.  Not sure if such a library exists in
> > usable form, but looking for segments owned by the downed postmaster's
> > pid would seem to be what is needed.  Just a thought...
>
> [ thinks about it... ]  Nah, it's still not bulletproof, because in a
> system reboot situation you can't trust the old PID either.  It could
> easy be that the other guy gets both the PID and the shmem ID that
> belonged to you last time.

I see.  Ipcs on my box also lists the date/time of shared memory segment
attach/detach/change (ipcs -t), but ...

> I've committed changes for 8.0 that mark a shmem segment with the inode
> of the associated data directory; that should be a stable enough ID to
> handle all routine-reboot cases.  (If you had to restore your whole
> filesystem from backup tapes, it might be wrong, but you're going to be
> doing such recovery manually anyway ...)

...that will remove a major hassle for us and lots of other.  Thanks.

Ed