Re: PostgreSQL crashes with Qmail-SQL

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: Bruce Momjian <pgman@candle.pha.pa.us>

Cc: Justin Clift <justin@postgresql.org>, Michael Devogelaere <michael@digibel.be>, Jan Wieck <janwieck@yahoo.com>, Stephan Szabo <sszabo@megazone23.bigpanda.com>, PostgreSQL Hackers Mailing List <pgsql-hackers@postgresql.org>

Date: 2002-01-25T01:14:44Z

Lists: pgsql-hackers

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> We added some PostgreSQL code to touch the socket file during
> checkpoints, and I thought that was in 7.1.

You're thinking about the socket lock file, which is a plain file.

The problem with socket files is that the file mod time usually doesn't
change even when it's in active use.  That's why things like
/tmp-scrubbers need to make an exception for socket files.

			regards, tom lane