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 'vpop3pass')

Then, type

SELECT sender,target,subject,r.username || '@' || r.domain as recipient FROM messages.outgoing INNER JOIN messages.outgoingrecipients r USING(msgid) INNER JOIN messages.outgoingtargets USING(msgid) ORDER BY msgid;

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