[GENERAL] Some problem with the NOTIFY/LISTEN

2011-01-19 Thread lee Richard
HI I am using PG 8.1.4, and my server was stop service, and when I checked the log, I found that some process had locked pg_listener in ExclusiveLock, it blocked all of the following processes which use NOTIFY/LISTEN. Can anyone tell me why pg_listener is locked forever? max

Re: [GENERAL] Some problem with the NOTIFY/LISTEN

2011-01-19 Thread Tom Lane
lee Richard clipper.ken...@gmail.com writes: I am using PG 8.1.4, and my server was stop service, and when I checked the log, I found that some process had locked pg_listener in ExclusiveLock, it blocked all of the following processes which use NOTIFY/LISTEN. Can anyone tell me why pg_listener