This shows you the differences between two versions of the page.
Previous revision | |||
— | reference:make_lan_forwarding_immediately_attempt_to_dequeue_all_pending_messages [2018/11/14 10:45] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ======Database query to make LAN Forwarding immediately attempt to dequeue all pending messages====== | ||
+ | If VPOP3 cannot send messages using LAN Forwarding it will queue the message and retry periodically. Usually there is no need to do anything special if there was a problem with the onward mail server which has now been fixed, VPOP3 should soon retry the messages automatically (based on the value of the **LAN Forwarding Retry Frequency** setting in the LAN Forwarding configuration). | ||
+ | |||
+ | However, if you want to force a retry sooner, you can use the following SQL command. | ||
+ | |||
+ | If you want an extra bit of safety, see the [[running database updates within a transaction]] article. | ||
+ | |||
+ | At a command prompt in the VPOP3 directory run | ||
+ | |||
+ | psql | ||
+ | | ||
+ | (The password is ' | ||
+ | |||
+ | Then, type | ||
+ | |||
+ | UPDATE messages.outgoing SET nexttry=now(); | ||
+ | | ||
+ | N.B. VPOP3 does not need to be stopped while you do this |