PostGreSQL 7.0.3 hangs in SuSE
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.
Did anyone experience the same issue?
Regards,
Stephan
--
Stephan Richter
CBU - Physics and Chemistry Student
Web2k - Web Design/Development & Technical Project Management
What happens exactly? If it "hangs", how and when does it "hang"? At
startup? After running a specific query?
-Mitch
Software development :
You can have it cheap, fast or working. Choose two.
----- Original Message -----
From: "Stephan Richter" <srichter@cbu.edu>
To: <pgsql-general@postgresql.org>
Sent: Friday, April 06, 2001 12:12 PM
Subject: PostGreSQL 7.0.3 hangs in SuSE
Show quoted text
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.Did anyone experience the same issue?
Regards,
Stephan--
Stephan Richter
CBU - Physics and Chemistry Student
Web2k - Web Design/Development & Technical Project Management---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
We're running compiled 7.0.3 on SuSE 7.1 without any problem.
Best regards,
Jan Pruner
Show quoted text
-----Original Message-----
From: Stephan Richter [mailto:srichter@cbu.edu]
Sent: Friday, April 06, 2001 6:13 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] PostGreSQL 7.0.3 hangs in SuSEHello 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.Did anyone experience the same issue?
Regards,
Stephan--
Stephan Richter
CBU - Physics and Chemistry Student
Web2k - Web Design/Development & Technical Project Management---------------------------(end of
broadcast)---------------------------
TIP 6: Have you searched our list archives?
Import Notes
Resolved by subject fallback
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/