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
