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