On Fri, 6 Apr 2001, Stephan Richter wrote:
> Hello everyone,
>
> did anyone notice that PostGres stops its services from time to time in
> SuSE. I do not have the problem with RedHat, my install there is running
> for several month smooth now, but the SuSE install gives me problems every
> second day or so.
> I tried all 7.0.x versions in source and binary form.
Maybe your cron.daily deletes the socket file
/tmp/.s.PGSQL.5432
Your postmaster should remain running, but clients cannnot
connect?
I had a similar problem and solved it by adding a touch
command to the cron.daily.local script
#
# Prevent cron.daily from deleting postmasters socket files:
#
if [ "$START_POSTGRES" = yes ] ; then
for TMP_DIR in $TMP_DIRS_TO_CLEAR ; do
find $TMP_DIR/. -type s -name .\*PGSQL.\* -exec /usr/bin/touch {} \;
done
fi
> ...
Hope this helps.
Regards
Martin
--
Dipl-Ing. Martin Jacobs * Windsbach * Germany
Registered Linux User #87175, http://counter.li.org/