PSCS Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

======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

PSCS Wiki

User Tools

Site Tools

Page Tools