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 revisionPrevious revision
Next revisionBoth sides next revision
how_to:delete_outqueue_messages_directly_from_the_database [2014/01/03 09:30] – [Accessing the VPOP3 database] paulhow_to:delete_outqueue_messages_directly_from_the_database [2014/01/03 09:31] – [To delete the messages] paul
Line 38: Line 38:
 etc. etc.
  
-After deleting the messages, you may want to shrink the disk file, otherwise there will be a lot of wasted disk space. To do this, at the psql prompt, do:+After deleting the messages, you may want to shrink the disk file, otherwise there may be a lot of wasted disk space if you have deleted an extremely large number of messages. To do this, at the psql prompt, do:
  
 ''CLUSTER VERBOSE outqueue.outmessages;\\ ''CLUSTER VERBOSE outqueue.outmessages;\\
 CLUSTER VERBOSE outqueue.outrecipients;'' CLUSTER VERBOSE outqueue.outrecipients;''
  
how_to/delete_outqueue_messages_directly_from_the_database.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1