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