Useful Database Queries

Below are some database (SQL) queries which may be useful in some situations. You can run these from the 'psql' program at the command prompt. Some can also be run from the Settings → Database → Query page in the VPOP3 settings.

• Export all lists & members
• Find forwards/assistants/etc
• Find message
• Find biggest messages
• Delete list member from all lists
• Copy SMTP Rules
• Password lengths

• Export LAN forwarding rules
• Alter LAN forwarding rules for one server to go to another
• List ALL messages in LAN forwarding queue
• List messages in LAN forwarding queue waiting to go to a specific server
• Alter LAN forwarding queued messages going to one server to go to another
• Make LAN forwarding immediately attempt to dequeue all pending messages

• View password change history
• List failed message send summary
• Sent message summary

In rare cases these may be needed. We recommend only using these if suggested by VPOP3 technical support!

• Reset message folder counts