Re: [GENERAL] Warning: Don't delete those /tmp/.PGSQL.* files

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [001125 16:37]:
> "Joel Burton" <jburton(at)scw(dot)org> writes:
>
> This story does indicate that we need a less fragile interlock against
> starting two postmasters on one database. I have to admit that it
> hadn't occurred to me that you could break the port-number interlock
> so easily as that :-(. But obviously you can, so we need a different
> way of representing the interlock. Hackers, any thoughts?
how about a .pid/.port/.??? file in the /data directory, and a lock on that?

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749