Postgres-Solaris Socket Bug - Mailing list pgsql-bugs

From Heiko Klein
Subject Postgres-Solaris Socket Bug
Date
Msg-id 199905311206.OAA07540@hydra.ikp.Uni-Koeln.DE
Whole thread Raw
List pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        :    Heiko Klein
Your email address    :    Heiko.Klein@ikp.uni-koeln.de


System Configuration
---------------------
  Architecture (example: Intel Pentium)      :SUN Enterprise 4000

  Operating System (example: Linux 2.0.26 ELF)     :Solaris 2.5.1

  PostgreSQL version (example: PostgreSQL-6.4.2)  :   PostgreSQL-6.4.2

  Compiler used (example:  gcc 2.8.0)        :SUN Workshop cc 4.2


Please enter a FULL description of your problem:
------------------------------------------------
Postgres is running very well! But after several days (3-7) the socket
dies and I get the message:
Connection to database 'http' failed.
connectDB() failed: Is the postmaster running and accepting connections
at 'UNIX Socket' on port '5432'?

Postmaster is still alive. The only thing I can do to reconnect is kill
the Postmaster-daemon and restart it. (Even a kill -SIGHUP doesn't work)

Except a daily VACUUM there wasn't any connection to postgres during the
complete uptime!


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

I'm running the precompiled version available at www.sunfreeware.com,
and even tried a a self-compiled version, both the same, socket-death
after several days.




If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------



pgsql-bugs by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: [BUGS] General Bug Report: prefix stringsearch doesn't return results
Next
From: jim@reptiles.org (Jim Mercer)
Date:
Subject: 6.5 indexes on timestamp/abstime don't appear to work