Is it reproduceable after a restart? Can you dump the production
data, reload on a test cluster, and reproduce it with any
consistency?
Can you post the output of these commands?
uname -a
export PGDATA=/path/to/your/data
egrep '^log_|lock' $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