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