Is it reproduceable after a restart? Can you dump the production
data, reload on a test cluster, and reproduce it with any
Can you post the output of these commands?
egrep '^log_|lock' $PGDATA/postgresql.conf
ps augxwww | egrep 'postgres|postmaster|PID'
psql -d template1 -c "select version()"
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
> can anybody please help me figure out how to find out what's
> thank you so much,
> Mona Gamboa
In response to
pgsql-admin by date
|Next:||From: Lee Harr||Date: 2003-02-17 23:25:04|
|Subject: Re: best way to make incremental back-ups?|
|Previous:||From: Ed Loehr||Date: 2003-02-17 22:58:58|
|Subject: Re: please help--database just locks up.|