Thread: 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/