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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
