Обсуждение: 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


> 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?
>
> http://www.postgresql.org/search.mpl
>

We're running compiled 7.0.3 on SuSE 7.1 without any problem.

Best regards,
Jan Pruner


> -----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 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>

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/