Re: Bug #882: Cannot manually log in to database.

pgsql-bugs@postgresql.org writes:
> okapview# /opt/pgsql-7.1.3/bin/psql -U postgres -d AppliedView
> psql: connectDBStart() -- connect() failed: No such file or directory
>         Is the postmaster running locally
>         and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?

> Stopping and starting the postmaster daemon clears up this problem, but this problem creeps up about 2 times a week,
andis a major annoyance. 

Sounds to me like you've got a cron script that removes everything in
tmp about twice a week.  I suggest teaching it not to remove socket
files.  On most Unixen the mod date on a socket file isn't changed by
normal activity, so a tmp-cleaner that only pays attention to the mod
date will mistakenly decide a socket is fair game for removal.

            regards, tom lane