Re: please help--database just locks up.

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: "Mona Gamboa" <mona(at)loopone(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: please help--database just locks up.
Date: 2003-02-18 01:25:48
Message-ID: 200302171825.48076.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Monday February 17 2003 4:31, Mona Gamboa wrote:
> ok...here's the output.[kinda nasty to read]

Nothing obvious to me. If it is reproduceable, you might try turning
on some of the lock tracing directives in postgresql.conf and/or
increasing the logging level. You might also try attaching to the
hung process in gdb to see where it is hanging, and post the
backtrace and see if anyone recognizes anything, e.g.

gdb <PATH-TO-PSQL> <PID>
gdb> bt

Ed

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2003-02-18 01:51:01 Re: pg_restore problem with 7.3.1
Previous Message Ed L. 2003-02-18 00:24:20 Re: server won't shutdown