Postgres-Solaris Socket Bug

From: Heiko Klein <hklein(at)ikp(dot)uni-koeln(dot)de>
To: pgsql-bugs(at)postgreSQL(dot)org
Subject: Postgres-Solaris Socket Bug
Date: 1999-05-31 12:06:18
Message-ID: 199905311206.OAA07540@hydra.ikp.Uni-Koeln.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Heiko Klein
Your email address : Heiko(dot)Klein(at)ikp(dot)uni-koeln(dot)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:
---------------------------------------------------------------------

Browse pgsql-bugs by date

  From Date Subject
Next Message Jim Mercer 1999-06-02 00:18:59 6.5 indexes on timestamp/abstime don't appear to work
Previous Message Josef Moser 1999-05-28 14:02:50 Re: [BUGS] General Bug Report: prefix stringsearch doesn't return results