Postgres-Solaris Socket Bug

Heiko Klein <hklein@ikp.uni-koeln.de>

From: Heiko Klein <hklein@ikp.uni-koeln.de>
To: pgsql-bugs@postgreSQL.org
Date: 1999-05-31T12:06:18Z
Lists: 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:
---------------------------------------------------------------------