Skip site navigation (1) Skip section navigation (2)

Re: pgsql/doc/TODO.detail (alpha default distinct flock fsync function limit null pg_shadow primary)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Bruce Momjian - CVS <momjian(at)hub(dot)org>, pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql/doc/TODO.detail (alpha default distinct flock fsync function limit null pg_shadow primary)
Date: 2000-07-04 19:39:23
Message-ID: 28151.962739563@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
eisentrp(at)csis(dot)gvsu(dot)edu writes:
> On Tue, 4 Jul 2000, Bruce Momjian - CVS wrote:
>> Removed Files:
>> alpha default distinct flock fsync function limit null 
>> pg_shadow primary 

> What are we going to do with the flock? Remove it? I asked about this
> yesterday, I guess it's not useful anymore.

It still is, because the $PGDATA pid file only guards against starting
two postmasters in the same data directory.  You still need some lock
against starting two postmasters on the same port number.  The TCP
socket address can take care of itself, but if one or both postmasters
is started without -i then there's got to be some interlock on the Unix
socket file.

I don't much like depending on flock for that, since it isn't available
everywhere.  The only portable answer is to build a pid-containing
interlock file for each socket file, as discussed in the TODO item.

It was premature of Bruce to delete the flock TODO file, since there is
still a lot of undone stuff in there concerning both this issue and
moving the Unix-socket file to a safer place than /tmp.

			regards, tom lane

PS: Hey Bruce, mail directly to your personal address
pgman(at)candle(dot)pha(dot)pa(dot)us has been bouncing since Sunday.

In response to

Responses

pgsql-hackers by date

Next:From: Tim PerdueDate: 2000-07-04 19:42:31
Subject: Article on MySQL vs. Postgres
Previous:From: Poul L. ChristiansenDate: 2000-07-04 19:15:22
Subject: Re: Article on MySQL vs. Postgres

pgsql-committers by date

Next:From: Peter Eisentraut - PostgreSQLDate: 2000-07-04 19:52:01
Subject: pgsql/src/bin/pg_dump (Makefile)
Previous:From: Jan WieckDate: 2000-07-04 17:11:40
Subject: pgsql/src/backend/access/heap (heapam.c)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group