User Tools

Site Tools


how_to:delete_outqueue_messages_directly_from_the_database

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
how_to:delete_outqueue_messages_directly_from_the_database [2014/06/10 10:30]
127.0.0.1 external edit
how_to:delete_outqueue_messages_directly_from_the_database [2015/09/23 12:46]
127.0.0.1 external edit
Line 43: Line 43:
 CLUSTER VERBOSE outqueue.outrecipients;''​ CLUSTER VERBOSE outqueue.outrecipients;''​
  
 +===Alternative method (quicker)===
 +
 +An alternate way to delete **ALL** the outqueue messages, and related information (but not settings or messages in mailboxes) is to stop VPOP3 first, and then use:
 +
 +''​DROP SCHEMA outqueue CASCADE;''​
 +
 +This will delete all the relevant tables from the database, including their contents, so will be a lot quicker. When you restart VPOP3 it will recreate the deleted tables. You cannot selectively delete messages in this case. If you are using some sort of third party database replication,​ such as Bucardo, then that may need reinitialising.
how_to/delete_outqueue_messages_directly_from_the_database.txt ยท Last modified: 2018/11/14 10:45 (external edit)