======Database query to list failed message sends======

This will list failed outgoing messages from the last 3 days (with the default VPOP3 settings)

At a command prompt in the VPOP3 directory run

  psql
  
(The password is 'vpop3pass')

Then, type

  select created,returnpath,subject,username || '@' || domain as recipient, latesterror 
  from outqueue.outrecipients inner join outqueue.outmessages using(msgid) where
  failedtime is not null order by created desc;

N.B. VPOP3 does not need to be stopped while you do this