If it's not sensitive information, what does this show?
>> lsof | grep 'pid of hung process'
>>
From my systems guy:
in /proc
codd 13262 # cat status {proc "filesystem"}
Name: postmaster
State: D (disk sleep)
Because of the "D" state, it can't be killed as it is not interuptible
(waiting on IO ?).
codd opt # lsof -p 13263
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
postmaste 13263 postgres cwd DIR 8,17 464 4030
/app1/user/postgres
postmaste 13263 postgres rtd DIR 8,3 488 2 /
postmaste 13263 postgres txt REG 8,17 2552859 5012
/app1/pg/7.4.9/bin/postgres
postmaste 13263 postgres mem REG 0,0 0 [heap]
(stat: No such file or directory)
postmaste 13263 postgres DEL REG 0,7 0 /SYSV0052e2c1
postmaste 13263 postgres mem REG 8,3 35428 5729
/lib/libnss_files-2.3.4.so
postmaste 13263 postgres mem REG 8,5 18852 6895
/usr/lib/libgpm.so.1.19.0
postmaste 13263 postgres mem REG 8,3 266284 5965
/lib/libncurses.so.5.4
postmaste 13263 postgres mem REG 8,3 1167808 5977
/lib/libc-2.3.4.so
postmaste 13263 postgres mem REG 8,3 151896 5755
/lib/libm-2.3.4.so
postmaste 13263 postgres mem REG 8,3 10620 5987
/lib/libdl-2.3.4.so
postmaste 13263 postgres mem REG 8,3 75848 6003
/lib/libnsl-2.3.4.so
postmaste 13263 postgres mem REG 8,3 60884 5998
/lib/libresolv-2.3.4.so
postmaste 13263 postgres mem REG 8,3 18424 6006
/lib/libcrypt-2.3.4.so
postmaste 13263 postgres mem REG 8,3 173996 6007
/lib/libreadline.so.4.3
postmaste 13263 postgres mem REG 8,3 63204 5976
/lib/libz.so.1.2.2
postmaste 13263 postgres mem REG 8,3 95392 5915
/lib/ld-2.3.4.so
postmaste 13263 postgres 0r CHR 1,3 2767 /dev/null
postmaste 13263 postgres 1w REG 8,7 7513385 3649
/var/log/pg/ruby.log.bak1
postmaste 13263 postgres 2w REG 8,7 7513385 3649
/var/log/pg/ruby.log.bak1
postmaste 13263 postgres 5u sock 0,4 11790654 can't
identify protocol