Re: pgsql 7.1.2 server hanging... - Mailing list pgsql-general

From Tom Lane
Subject Re: pgsql 7.1.2 server hanging...
Date
Msg-id 1405.993519954@sss.pgh.pa.us
Whole thread Raw
In response to pgsql 7.1.2 server hanging...  (Ed Loehr <eloehr@austin.rr.com>)
List pgsql-general
Ed Loehr <eloehr@austin.rr.com> writes:
> I am trying out postgresql 7.1.2.  I'm experiencing a hung server on
> linux 2.4.2-2 when I run a sql script that drops & reloads many PL/pgSQL
> functions and triggers, as well as hanging during VACUUM ANALYZE.

Are you sure it's hung, and not just waiting on some open transaction
in another backend that's holding a lock on some table?  There's nothing
even slightly unusual about the log excerpts you're showing...

            regards, tom lane

pgsql-general by date:

Previous
From: lbayuk@mindspring.com (ljb)
Date:
Subject: Re: 7.1.2 ERROR: UNIQUE constraint matching given keys for referenced table ......
Next
From: "Dave Cramer"
Date:
Subject: RE: PostgreSQL: YMMV?