This shows you the differences between two versions of the page.
Previous revision | |||
— | reference:list_messages_in_lan_forwrding_queue_waiting_to_go_to_a_specific_server [2018/11/14 10:45] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ======Database query to list messages in the LAN forwarding queue waiting to go to a specific server====== | ||
+ | The VPOP3 settings show the first 100 messages in the LAN forwarding queue. Usually this is sufficient as the LAN forwarding queue is usually nearly empty, but in case of a problem it may be much bigger. The database queries below let you list just messages going to a specific server. | ||
+ | |||
+ | At a command prompt in the VPOP3 directory run | ||
+ | |||
+ | psql | ||
+ | | ||
+ | (The password is ' | ||
+ | |||
+ | Then, type | ||
+ | |||
+ | SELECT sender, | ||
+ | | ||
+ | to list all the messages in the LAN forwarding queue going to the server "< | ||
+ | |||
+ | or use | ||
+ | |||
+ | SELECT count(*) FROM messages.outgoingtargets WHERE target='< | ||
+ | | ||
+ | to simply get a count of the number of messages in the queue for that server. | ||
+ | |||
+ | |||
+ | N.B. VPOP3 does not need to be stopped while you do this |