Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA04307; Tue, 15 Sep 92 08:59:42 -0700
Date: Tue, 15 Sep 92 08:59:42 -0700
Message-Id: <9209151559.AA04307@postgres.Berkeley.EDU>
From: klein@imasun.lbl.gov (Gregory Klein)
Subject: forever waiting postgres processes
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu


Since installing Postgres ver 4.1, I have noticed that programs which
issue postgres commands via libpq occasionally hang, creating a
postgres process in a wait state.  Once this happens, all subsequent
calls to the backend will not go through, whether they are issued from
another libpq program, or from the monitor directly.  The only way to
fix it is to kill the wait-stated postgres process.  This problem didn't
exist when I was using the same programs and database with version
3.1.  Has anyone else experienced this problem?  I am running postgres
on a SPARC IPX running SunOS 4.1.2.

Thanks for any help,
Greg Klein