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 revision
Previous 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/06/10 11:30] – external edit 127.0.0.1
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