Re: please help--database just locks up.

From: Ed Loehr <ed(at)LoehrTech(dot)com>
To: "Mona Gamboa" <mona(at)loopone(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: please help--database just locks up.
Date: 2003-02-17 22:58:58
Message-ID: 200302171558.58222.ed@LoehrTech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Can you post the output of these commands?

uname -a
export PGDATA=/path/to/your/data
grep ^log_ $PGDATA/postgresql.conf
cat $PGDATA/postmaster.pid
ps augxwww | egrep 'postgres|postmaster|PID'
psql -d template1 -c "select version()"
uptime
df $PGDATA

Regards,
Ed

On Monday February 17 2003 3:16, Mona Gamboa wrote:
> we are running linux and postgres7.3.2 in a production environment.
>
> the database just 'locks ups.' if i try to get into psql X [where
> X is my database or template 0 or template 1] it just sits there.
> the log files don't say anything......there's no indication as to
> what is happening.
>
> if i look at top it says 100% idle, and the postmaster is
> supposedly still running, as i see it when i do a ps auuwx| grep
> ^postgres....
>
> can anybody please help me figure out how to find out what's
> happening?
>
> thank you so much,
>
> Mona Gamboa

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ed L. 2003-02-17 23:06:56 Re: please help--database just locks up.
Previous Message Laurette Cisneros 2003-02-17 22:56:24 Re: server won't shutdown