This shows you the differences between two versions of the page.
Previous revision | |||
— | reference:list_failed_message_send_summary [2018/11/14 10:45] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ======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 ' | ||
+ | |||
+ | Then, type | ||
+ | |||
+ | select created, | ||
+ | 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 | ||