Re: fcntl(SETLK) [was Re: 2nd update on TOAST]

* Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> [000708 06:02] wrote:
> > > my $pgsocket = "/tmp/.s.PGSQL.5432";
> > >
> > > # try to connect to the postmaster
> > > socket(SOCK, PF_UNIX, SOCK_STREAM, 0)
> > > or die "unable to create unix domain socket: $!";
> > >
> > > connect(SOCK, sockaddr_un($pgsocket))
> > > and errexit("postmaster is running you must shut it down");
> > >
> > > oh yeah... :)
> > >
> > > -Alfred
> >
> > I don't get this. Isn't there a race condition here?
>
> That's a good point. I don't think so because the socket will only
> create for one user. Basically, we don't need something bulletproof
> here. We just need something to prevent admins from accidentally
> starting two postmasters on the same port.

Actually I just remebered the issue here, if one wants to start
postmaster on an alternate port there will be no conflict and
all hell may break loose.

-Alfred