Re: hung postmaster?

Here's the lsof output for the hung processes...


$ lsof | egrep 'PID|28775|29080|26752'
COMMAND    PID USER   FD   TYPE             DEVICE SIZE/OFF     NODE NAME
psql     26752   pg  cwd    DIR             64,0x9     2048    12677 /users/pg
psql     26752   pg  txt    REG             64,0x6   242192    50102 /opt (/dev/vg00/lvol6)
psql     26752   pg  mem    REG             64,0x8      532     2544 /var/spool/pwgr/status
psql     26752   pg  mem    REG             64,0x7   312328     5931 /usr/lib/hpux64/libxti.so.1
psql     26752   pg  mem    REG             64,0x7  1597816    20621 /usr/lib/hpux64/libnsl.so.1
psql     26752   pg  mem    REG             64,0x7  4279160     5873 /usr/lib/hpux64/libc.so.1
psql     26752   pg  mem    REG             64,0x7  2068376     5891 /usr/lib/hpux64/libm.so.1
psql     26752   pg  mem    REG             64,0x7    22848     5878 /usr/lib/hpux64/libdl.so.1
psql     26752   pg  mem    REG             64,0x7    40016     5883 /usr/lib/hpux64/libgen.so.1
psql     26752   pg  mem    REG             64,0x7    37928     5929 /usr/lib/hpux64/libxnet.so.1
psql     26752   pg  mem    REG             64,0x6   218824    50167 /opt (/dev/vg00/lvol6)
psql     26752   pg  mem    REG             64,0x7   705704     5869 /usr/lib/hpux64/dld.so
psql     26752   pg  mem    REG             64,0x7   157912     5925 /usr/lib/hpux64/uld.so
psql     26752   pg    0u   STR            157,0x3 0t885971      955 ldterm->ptem->pts
psql     26752   pg    1u   STR            157,0x3 0t885971      955 ldterm->ptem->pts
psql     26752   pg    2u   STR            157,0x3 0t885971      955 ldterm->ptem->pts
psql     26752   pg    3u  unix             64,0x8      0t0     8046 /var/spool/sockets/pwgr/client26752 (0x743e5900)
psql     26752   pg    4u  unix         0x6f1963c0      0t0          ->0x74a76740
postgres 28775   pg  cwd    DIR             64,0x9     2048    12677 /users/pg
postgres 28775   pg  txt    REG             64,0x6  5071608    50092 /opt (/dev/vg00/lvol6)
postgres 28775   pg  mem    REG             64,0x7    13197     6216 /usr/lib/tztab
postgres 28775   pg  mem    REG             64,0x7   312328     5931 /usr/lib/hpux64/libxti.so.1
postgres 28775   pg  mem    REG             64,0x7  1597816    20621 /usr/lib/hpux64/libnsl.so.1
postgres 28775   pg  mem    REG             64,0x7   135488     5892 /usr/lib/hpux64/libnss_files.so.1
postgres 28775   pg  mem    REG             64,0x7  4279160     5873 /usr/lib/hpux64/libc.so.1
postgres 28775   pg  mem    REG             64,0x7  2068376     5891 /usr/lib/hpux64/libm.so.1
postgres 28775   pg  mem    REG             64,0x7    22848     5878 /usr/lib/hpux64/libdl.so.1
postgres 28775   pg  mem    REG             64,0x7    40016     5883 /usr/lib/hpux64/libgen.so.1
postgres 28775   pg  mem    REG             64,0x7    37928     5929 /usr/lib/hpux64/libxnet.so.1
postgres 28775   pg  mem    REG             64,0x7   705704     5869 /usr/lib/hpux64/dld.so
postgres 28775   pg  mem    REG             64,0x7   157912     5925 /usr/lib/hpux64/uld.so
postgres 28775   pg    0u   CHR              3,0x2      0t0       65 /dev/null
postgres 28775   pg    1u   REG             64,0x9    28137    49084 /users/pg/server_log
postgres 28775   pg    2u   REG             64,0x9    28137    49084 /users/pg/server_log
postgres 28775   pg    3u  sock                         0t0          unsupported family: AF_22
postgres 28775   pg    4u  inet 0xe0000001742b8900      0t0      TCP *:19001 (LISTEN)
postgres 28775   pg    5u  unix             64,0x4      0t0      138 /tmp/.s.PGSQL.19001 (0x74974ac0)
postgres 28775   pg    6u  inet 0xe00000016ef5f580      0t0      UDP localhost:55276->localhost:55276 (Idle)
postgres 28775   pg    7r  FIFO 0xe00000016a1bc748      0t0 16368987
postgres 28775   pg    8w  FIFO 0xe00000016a1bc748      0t0 16368987
psql     29080   pg  cwd    DIR             64,0x9     2048    12677 /users/pg
psql     29080   pg  txt    REG             64,0x6   242192    50102 /opt (/dev/vg00/lvol6)
psql     29080   pg  mem    REG             64,0x8      532     2544 /var/spool/pwgr/status
psql     29080   pg  mem    REG             64,0x7   312328     5931 /usr/lib/hpux64/libxti.so.1
psql     29080   pg  mem    REG             64,0x7  1597816    20621 /usr/lib/hpux64/libnsl.so.1
psql     29080   pg  mem    REG             64,0x7  4279160     5873 /usr/lib/hpux64/libc.so.1
psql     29080   pg  mem    REG             64,0x7  2068376     5891 /usr/lib/hpux64/libm.so.1
psql     29080   pg  mem    REG             64,0x7    22848     5878 /usr/lib/hpux64/libdl.so.1
psql     29080   pg  mem    REG             64,0x7    40016     5883 /usr/lib/hpux64/libgen.so.1
psql     29080   pg  mem    REG             64,0x7    37928     5929 /usr/lib/hpux64/libxnet.so.1
psql     29080   pg  mem    REG             64,0x6   218824    50167 /opt (/dev/vg00/lvol6)
psql     29080   pg  mem    REG             64,0x7   705704     5869 /usr/lib/hpux64/dld.so
psql     29080   pg  mem    REG             64,0x7   157912     5925 /usr/lib/hpux64/uld.so
psql     29080   pg    0u   STR            157,0xb 0t182144      963 ldterm->ptem->pts
psql     29080   pg    1u   STR            157,0xb 0t182144      963 ldterm->ptem->pts
psql     29080   pg    2u   STR            157,0xb 0t182144      963 ldterm->ptem->pts
psql     29080   pg    3u  unix             64,0x8      0t0     8040 /var/spool/sockets/pwgr/client29080 (0x70b593c0)
psql     29080   pg    4u  unix         0x742b8580      0t0          ->0x717b6040