This shows you the differences between two versions of the page.
Last revision | |||
— | reference:list_all_messages_in_lan_forwrding_queue [2014/11/21 09:58] – created paul | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ======Database query to list ALL messages in the LAN forwarding queue====== | ||
+ | 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 may help in that situation. | ||
+ | |||
+ | 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 | ||
+ | |||
+ | or use | ||
+ | |||
+ | SELECT count(*) FROM messages.outgoing; | ||
+ | | ||
+ | to simply get a count of the number of messages in the queue | ||
+ | |||
+ | |||
+ | N.B. VPOP3 does not need to be stopped while you do this |