https://wiki.pscs.co.uk/ 2026-05-06T11:00:05+00:00 https://wiki.pscs.co.uk/ https://wiki.pscs.co.uk/_media/wiki:dokuwiki.svg text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:restore_a_backup_of_vpop3?rev=1542192349&do=diff How to Restore a backup of VPOP3 The instructions below are to restore a full backup. You may also be able to recover deleted messages if you do not need to restore a full backup. Version 5 or later If you just need to restore a database backup, see steps 4 to 7 below. text/html 2018-12-05T15:25:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:v3_-_move_message_store_folder?rev=1544023524&do=diff v3/4 - Move the message store to a new folder/drive This guide assumes you want to just move the VPOP3 message store/database to a new folder on the same PC, and leave the VPOP3 installation directory where it is. * Stop VPOP3 * Stop PostgreSQL text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/faq:what_is_postgresql?rev=1542192349&do=diff What is PostgreSQL? PostgreSQL is an SQL database engine. VPOP3 and PostgreSQL In VPOP3 2.x, VPOP3 uses a database engine called SQLite for its database needs. SQLite has limited locking facilities, so on busy systems we encountered problems where databases would need very frequent updates, and the lock limitations would cause the updates to take a long time. For this reason we added optional support for PostgreSQL to later versions of VPOP3 2.x. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:database_maintenance?rev=1542192349&do=diff Database Maintenance VPOP3 uses the PostgreSQL database server for most of its data storage. Normally this will not require any special maintenance, because it will manage itself. To do any special database maintenance you will need to close down VPOP3 first, because PostgreSQL needs exclusive access to the database to perform any operations such as decreasing the size of database files. Note that these operations may take some time! There are some PostgreSQL utility programs in the VPOP3\pgs… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:v3_-_move_message_store?rev=1542192349&do=diff How to move the VPOP3 Message Store to a new PC Use this option if you want to have VPOP3 running on one PC, but have the message store database on another PC. Manually Install PostgreSQL on the new PC Download the 'pgInstaller' version of PostgreSQL from the text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:backup_vpop3?rev=1542192349&do=diff How to Backup VPOP3 By default VPOP3 v3 and later will automatically perform a daily backup of the database into a file called DBBACK-x.DMP, where the backup file rotates on a weekly basis (DBBACK-0.DMP is Sunday's backup, DBBACK-1.DMP is Monday's backup, etc). text/html 2019-11-12T16:10:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:v5_-_move_the_message_store_to_a_new_folder_drive?rev=1573575042&do=diff v5 - Move the message store to a new folder/drive Here is an alternative method, which may be simpler, but only moves the data, not the whole database store (which is a subtle difference) This guide assumes you want to just move the VPOP3 message store/database to a new folder on the same PC, and leave the VPOP3 installation directory where it is. text/html 2018-12-05T15:25:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:v3_-_move_to_a_new_folder?rev=1544023541&do=diff How to move VPOP3 V3 to a new folder This guide assumes you want to move the whole of VPOP3 (including the message store) to a new folder on the same PC * Stop VPOP3 * Stop PostgreSQL * Remove the PostgreSQL service * Move VPOP3 to the new folder text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:installing_postgresql_database_on_another_port?rev=1542192349&do=diff How to install PostgreSQL to use another port If the VPOP3 computer has a version of PostgreSQL older than version 8.3 installed for other software, and you can't/don't want to remove that you need to set up the PostgreSQL 8.3 or later for VPOP3 to use a different TCP/IP port number. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:database_schema_used_in_vpop3_5.x?rev=1542192349&do=diff Database schema used in VPOP3 5.x Note that all information in this section is subject to change. We do not guarantee that the database schema will remain constant, even between minor upgrade versions, so use this information at your own risk. Do not alter the database schema used by VPOP3 (including indexes, triggers & functions) or your whole VPOP3 data store may collapse. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:postgresql_server_won_t_start_due_to_damaged_log_files?rev=1542192349&do=diff PostgreSQL server won't start due to damaged log files If the PostgreSQL server won't start at all, because its transaction logs are damaged, you will probably need to recreate the database store totally. To rebuild the database: * Open a command prompt and find the VPOP\pgsql folder text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/fatal:connection_limit_exceeded_for_non-superusers?rev=1542192349&do=diff FATAL: connection limit exceeded for non-superusers This error means that there are too many connections to the PostgreSQL database server. VPOP3 having exclusive use of database If only VPOP3 is using the PostgreSQL database, then you can reduce the number of connections that VPOP3 will make to the database at once. This is set in the VPOP3 settings at text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:database_backups?rev=1542192349&do=diff Database -> Backups Tab The Backups tab lets you specify how VPOP3 will make its daily backup of its database. We strongly recommend that you backup the database regularly in case of disk problems or file corruption. You can use the VPOP3 backup feature, or manually backup the PostgreSQL database using the pg_dump command, or use another program to backup the PostgreSQL database if you wish. Note that a simple disk copy will text/html 2025-09-11T13:02:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:database_issues?rev=1757595765&do=diff Database Issues VPOP3 version 3 and later use the PostgreSQL] database server. This is an open source enterprise level database server. Several VPOP3 problems are due to problems with the database service. * Database & Disk Caching * Software conflicting with database * VPOP3DB Service not starting * Database Size Database corruption If VPOP3 won't start even though the process is running, then that is often because the PostgreSQL service is not running. If the PostgreSQL service won… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:vpop3_not_starting_properly?rev=1542192349&do=diff VPOP3 Not Starting Properly If VPOP3 is not starting properly, then the first thing to check is whether the database server is starting. In VPOP3 v3 and later, VPOP3 uses a PostgreSQL Database server for data storage, so if the database server is not running, VPOP3 will not be able to start properly. In this case, the VPOP3.EXE process may appear in Task Manager, but it won't respond to anything, or it may appear in Task Manager and then stop after a short period. text/html 2019-02-06T17:10:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:postgresql_replication?rev=1549473031&do=diff PostgreSQL Replication PostgreSQL 9.1 (used in VPOP3 5 and later) supports replication from a 'Master' to a 'Slave' database server. This can be used with VPOP3 for having a near-realtime backup of your settings & messages. To use the replication, you need to have a file share which is accessible from both PCs. The thing to watch out for is that the PostgreSQL services may be running as a different user from the currently logged in user, so make sure that the user(s) which the PostgreSQL servi… text/html 2024-01-15T11:35:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:repairing_corrupted_database?rev=1705318545&do=diff Repairing corrupted database With PostgreSQL (as with most high-end databases) the database system will automatically recover after power failures etc, if it can. If it can't then there is no manual 'repair' function, because the data cannot totally be recovered (or it would automatically have been recovered). text/html 2020-06-29T10:43:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:upgrade_vpop3_to_version_7?rev=1593427438&do=diff How to upgrade VPOP3 to version 7 or later from version 6 or earlier As usual the process to upgrade is simply to install the later version over your existing installation (do not uninstall anything first). The below is technical information detailing an extra step performed by the installer in this particular upgrade step. text/html 2020-09-03T15:07:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:upgrade_vpop3_to_version_8?rev=1599145654&do=diff Upgrading VPOP3 to version 8.x from v7 or earlier VPOP3 v8.x uses PostgreSQL 10 as its database engine, which is the latest supported 32 bit version of PostgreSQL. Later versions of PostgreSQL are 64-bit only, which means we cannot use them while continuing to support 32 bit versions of Windows. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:vpop3_historical_logger_backlog?rev=1542192349&do=diff VPOP3 Historical Logger Backlog This problem is primarily related to VPOP3 versions 2.5 -> 2.6. Theoretically it could happen on later versions, but would be extremely unusual (see the note at the bottom if you are using version 3.0 or later) You get an error message with subject text/html 2021-03-08T10:48:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:install_vpop3?rev=1615200520&do=diff How to Install VPOP3 Simply download VPOP3 from the website, and run the installation program and follow the prompts. Occasionally people may have problems with the PostgreSQL part of the installation. If that happens, please contact us either by email at support@pscs.co.uk or by phone to +44 (0)1484 855800, and we will do our best to help. text/html 2025-12-17T09:19:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:restore_a_database_backup?rev=1765963180&do=diff Restore a database backup By default VPOP3 makes a daily backup of the VPOP3 database to a file 'DBBACK-n.DMP' in the VPOP3 installation directory (it is possible to change this in the settings). These are cycled on a weekly basis so you will usually have the last seven days' worth of backups. These can be useful if the database gets damaged somehow. text/html 2019-11-08T15:37:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:upgrade_vpop3_to_version_5?rev=1573227472&do=diff How To Upgrade VPOP3 to version 5 or later Upgrading VPOP3 is usually a straightforward process. Download VPOP3 from our web site and back up your current installation just in case something goes wrong. Then simply run the installer that you downloaded and install it over the top of your existing VPOP3. All your settings and mail will be preserved. text/html 2026-03-18T20:49:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:upgrade_vpop3_to_version_9?rev=1773866994&do=diff Upgrading VPOP3 to version 9.x from v7 or v8 VPOP3 v9 and later requires a 64 bit version of Windows 8.1 or later VPOP3 v9.x uses PostgreSQL 18 as its database engine. This can only easily be upgraded from PostgreSQL 9.3 or later, which means it must be an upgrade of VPOP3 v7 or later. If you are using an earlier version of VPOP3, then upgrade it to v8.7 first, then upgrade to v9 or later text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:upgrading_database_software?rev=1542192349&do=diff Upgrading PostgreSQL Database Software To upgrade the PostgreSQL database software used by VPOP3 * stop VPOP3 * backup the database (<http://wiki.pscs.co.uk/how_to;backup_vpop3#manual_database_backup1>) * uninstall PostgreSQL (from within Windows) if necessary * rename the VPOP3\pgsql folder to something else text/html 2021-03-19T16:01:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:v5_-_move_to_a_new_folder?rev=1616169708&do=diff How to move VPOP3 V5+ to a new folder This guide assumes you want to move the whole of VPOP3 (including the message store) to a new folder on the same PC * Stop VPOP3 * Stop VPOP3DB * Remove the VPOP3DB service * Move VPOP3 to the new folder text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:vpop3_cannot_access_postgresql_-_timeout_expired?rev=1542192349&do=diff VPOP3 cannot access PostgreSQL - timeout expired This is an error which may be logged in the Windows event log It is event 4547 from the source 'VPOP3' If the event message DLL is not correctly installed it may display as: The description for Event ID ( 4547 ) in Source ( VPOP3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this desc… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:full_text_search?rev=1542192349&do=diff Full Text Search In VPOP3 Enterprise v7.0 a facility for full-text-search on message content was added. Because the full-text-search indexes can be quite big, this facility is optional. For several reasons, the full-text-search is stored in a separate PostgreSQL database. This means that it is not backed up with your standard backups. After a restore, the full-text-search index can be rebuilt from the raw message content. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:many_instances_of_postgres.exe_running?rev=1542192349&do=diff Many instances of Postgres.exe are running If you are running VPOP3 3.0 or later, and look in the 'Processes' list in Windows TaskManager you will probably see multiple instances of postgres.exe running. This is perfectly normal, and does not indicate a problem. The PostgreSQL database works by having a separate instance of postgres.exe for each connection to the database (as well as a few extra for management and house keeping). This behaviour is documented on the text/html 2019-11-12T16:09:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:v3_-_move_to_a_new_pc?rev=1573574948&do=diff Move VPOP3 Version 3 or 4 to a new PC Moving VPOP3 Version 3 or 4 to a new PC is slightly different from moving earlier versions, because of the database system. The summary of steps is: * Stop VPOP3 on the original PC * Manually make a backup of the database on the original PC text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/mailapi:autoresponderconditionlist?rev=1542192349&do=diff AutoresponderConditionList Replacement Use: ~autoresponderconditionlist~ Required parameter: responderid - the ID of the autoresponder This returns a JSON structure containing an array of the rules associated with the specified autoresponder. The return structure is an array of objects containing: text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_db_comparator?rev=1542192349&do=diff Spamfilter database comparators Several Spamfilter DB statements allow comparators which are listed below If the value specified in the statement is numeric: * = or == compare numeric values for equality * <> or != compare numeric values for inequality text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:users_autoresponderconditions?rev=1542192349&do=diff Users.AutoresponderConditions table The Users.AutoresponderConditions table contains a record of all autoresponder trigger conditions created in VPOP3. These tell VPOP3 when a particular autoresponder should fire for a particular user. Each autoresponder can have zero or more conditions. An autoresponder with zero conditions will never fire but can be reactivated later by adding a new condition. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:database_backup_failed?rev=1542192349&do=diff Database Backup Failed VPOP3 version 3 and later will, by default, make a backup of the database used by VPOP3 into a file. This uses the PostgreSQL utility 'pg_dump' If an error occurs whilst running this program, VPOP3 will create a 'Database Backup Failed' error message to the administrator. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:database_size?rev=1542192349&do=diff VPOP3 Database Size The VPOP3 directory is stored in the VPOP3\pgsql\data folder and subfolders. If you are concerned about the size of the VPOP3 database, there are several factors which may make the database larger than you would expect: * The VPOP3 database contains a lot more information than just messages in mailboxes. This can include settings, outgoing messages, historical logging information, statistical information for the spamfilter, information about archived messages, etc. Also,… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:install_to_external_pgsql?rev=1542192349&do=diff Install VPOP3 using external PostgreSQL database (VPOP3 version 5 or later) In some cases, advanced users may wish to have VPOP3 use an external PostgreSQL database instead of the one installed with VPOP3. This is possible by telling VPOP3 the connection details during installation. text/html 2026-04-21T11:12:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:v5_-_move_to_a_new_pc?rev=1776769960&do=diff Move VPOP3 Version 5 (or later) to a new PC Moving VPOP3 Version 5 or later to a new PC is slightly different from moving earlier versions, because of the database system, which was introduced for version 3 and modified for version 5. The summary of steps is: * Stop VPOP3 on the original PC text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:estimate_db_upgrade_time?rev=1542192349&do=diff How to estimate Database Upgrade Time When upgrading from VPOP3 version 3 or 4 to version 5, the PostgreSQL database engine needs to be upgraded. This involves backing up the database data, upgrading the database engine, then restoring the data. This can take some time on large databases. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:move_the_message_store_-_alternative_method?rev=1542192349&do=diff Move the message store - alternative method This method moves the database data storage location, but not the whole database. This means that the database configuration, logs, transaction logs etc are still stored in the VPOP3\pgsql\data folder, but the actual database tables & indexes are stored in the new location. This may be simpler, but, depending on your requirements, text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:obtaining_windows_event_log?rev=1542192349&do=diff Obtaining Windows Event Log Sometimes, the VPOP3 technical support team may need to see entries from the Windows Event log, especially those relating to VPOP3 or the PostgreSQL service. If there are too many entries simply to copy, you can save them to a file to email to technical support. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:problem_installing_postgresql?rev=1542192349&do=diff Problems with installing PostgreSQL during VPOP3 Installation Sometimes people have problems with the PostgreSQL installation part of the VPOP3 installation. Below are some things to look at. * Check that 'Local System' (or 'System') has full access to the VPOP3 installation directory text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:restore_folder_-_v5?rev=1542192349&do=diff Restore selected mail folders or mailbox in VPOP3 v5 or later (This option is only available in VPOP3 Enterprise) First - if the problem is that messages were deleted very recently (the default is within 3 days), you can probably use the Undelete feature in VPOP3. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:database_restore?rev=1542192349&do=diff Database -> Restore Tab This tab is only in VPOP3 Enterprise (v5 and later), and is for performing a partial (mailbox/mail folder) restore of the database. To do a full restore of the database, or for VPOP3 Basic/Standard, see the “Restore a Backup of VPOP3” topic Using the text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_statement_dbdeletetime?rev=1542192349&do=diff Spam Filter Rules: DBDeleteTime Statement DBDeleteTime Version 6.16+ Purpose Deletes records from the spam filter database based on their last update time The DBDeleteTime statement requires a component name, comparator and time value, in the format text/html 2026-03-18T20:51:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/faq:faq?rev=1773867093&do=diff Frequently Asked Questions Pre-Sales Questions * What is the difference between VPOP3 Basic/Standard and VPOP3 Enterprise? * Do I have to pay VAT? * Will I receive a VAT invoice? * What are the limitations of the Home User licence Sales Questions * How can I place an order? * Can I add two licences together? * I got a copy of VPOP3 via Trialpay and would like a refund General * How do I get support? * VPOP3 Roadmap * What do I do if I have lost my VPOP3 licence details?… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:alternative_method_of_automatically_starting_vpop3?rev=1542192349&do=diff Alternative method of automatically starting VPOP3 VPOP3 usually automatically starts as a Windows service. Sometimes this does not work, either because other services need to start first, or Windows is going very slowly at startup, causing the database service to time out, or there are certain database control files which did not get cleared after a previous Windows shutdown. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:c_error_popup?rev=1542192349&do=diff C++ Error Popup If VPOP3 crashes with a C++ error popup window, that means that an 'exception' has been thrown - something unusual has happened, and VPOP3 doesn't know how to recover automatically. Often these are due to database errors. There are two places you can look for the cause of the error: text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:compatibility_with_spampal?rev=1542192349&do=diff Compatibility with SpamPal Some users have reported a problem installing/running the PostgreSQL component when the 'SpamPal SMTP Transparent Feature' is enabled. Disabling this feature has resolved the problem for these users. Unfortunately we don't have further information on this, as we don't use SpamPal ourselves, but the above information may be useful if you have this problem. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:database_disk_caching?rev=1542192349&do=diff Database & Disk Caching Disk Caching One key point is that, like all other high-end databases, PostgreSQL should not be run on a server with disk level write back caching. With write back caching, the disk will report data as being written to disk when it is still in the disk's cache memory. If the power then fails, this data is lost and can cause database corruption. As long as the database server really knows when the data has been written to disk, power failure will not cause database corru… text/html 2025-10-06T15:21:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:error_messages?rev=1759764097&do=diff Error Messages This is the place to look if you are trying to trouble shoot a problem and you have received or have access to a specific error message or error code. If instead your problem is that something you think is set up correctly is not working then the best place to look would be the text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:installation_errors?rev=1542192349&do=diff Installation Errors This page lists some errors which may occur during installation and the solution. In general, do NOT 'ignore' any errors unless we tell you to. If you have to retry an installation, when it is an upgrade from versions 1 - 4 going to version 5 or later, then make sure you have told the installer to install the database. Sometimes a partial installation will make the installer think that the database is already installed. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:localhost_missing_from_vista_hosts_file?rev=1542192349&do=diff Localhost missing from Vista HOSTS file The PostgreSQL database server needs to be able to resolve the 'localhost' name for it to run. On some Windows Vista installations, the HOSTS file seems to be missing the localhost entry (usually it is there, but it seems to be a common problem for it not to be there). text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:manually_installing_the_postgresql_database_server?rev=1542192349&do=diff Manually installing the PostgreSQL Database Server <flashplayer width=640 height=500>file=<http://wiki.pscs.co.uk/Media/installpgsql91.mp4&image=http://wiki.pscs.co.uk/Media/installpgsql91.png></flashplayer> text/html 2022-11-18T11:43:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:restore_deleted_calendars?rev=1668771832&do=diff Restore Deleted Calendars This article will help if a user has been deleted and all their calendars are lost and need to be restored. Note that this functionality is not built into VPOP3, and requires the use of Python3 to run a script First you need to install Python 3.8 or later, and the psycopg2 plugin text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:tutorials?rev=1542192349&do=diff Video Tutorials * Download & Install VPOP3 * Manually installing the PostgreSQL database server * Move the VPOP3 message store to a new folder/drive - V5 text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:vpop3db_service_doesn_t_exist?rev=1542192349&do=diff VPOP3DB Service doesn't exist If VPOP3 v3 or later won't start, and you find that the VPOP3DB (or PostgreSQL-VPOP3) service does not exist in the Windows Services list, it may be that you have just moved VPOP3 and made a mistake following the move procedure or something has removed the service for some reason. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:calendar_calendars?rev=1542192349&do=diff Calendar.Calendars table The Calendar.Calendars table contains a list of all 'calendars' created in VPOP3. Each user account has at least one calendar Columns * calid - this is a integer sequential value which identifies the calendar uniquely in the database * text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:calendar_events?rev=1542192349&do=diff Calendar.Events table The Calendar.Events table contains a record of all the events in calendars managed by VPOP3. An 'event' is an iCalendar event. Note that if an event is a recurring series, there will only be one 'event' in the database, not one event per instance of the recurrence. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:copy_smtp_rules?rev=1542192349&do=diff Copy SMTP Rules - Database Query This is an advanced Database action. There is no simple query that will perform the required operation, so we have to create a custom PostgreSQL function to copy the data. At a command prompt in the VPOP3 directory run text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:database_message_store?rev=1542192349&do=diff Database -> Message Store Tab This tab says how VPOP3 handles its message store Message Store The Delay while moving messages setting tells VPOP3 how quickly to import messages into the new database structure if it was upgraded from version 2.x or earlier. Usually this is OK to be left as it is, but if there is some special requirement to import the messages more quickly, you can decrease this number, but that will increase the load on the server. text/html 2026-03-16T11:12:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:group_a_user_s_folders_into_letter_groups?rev=1773659562&do=diff Group a user's folders into letter groups This is useful in VPOP3 Enterprise if you have a large folder with many subfolders and want to group the subfolders into other subfolders based on their first letter For example, if you have * Customers text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:logdb_attachments?rev=1542192349&do=diff LogDB.Attachments table The LogDB.Attachments table contains a record of the attachments for messages logged by VPOP3. A message may have zero or more attachments Columns * attachid - this is a bigint sequential value which identifies the attachment uniquely in the database text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:logdb_messages?rev=1542192349&do=diff LogDB.Messages table The LogDB.Messages table contains a record of all messages logged by VPOP3. A message is logged when a message is sent/received/etc. Columns * msgid - this is a bigint sequential value which identifies the message uniquely in the database text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:logdb_recipients?rev=1542192349&do=diff LogDB.Recipients table The LogDB.Recipients table contains a record of the recipients for messages logged by VPOP3. A message may have one or more recipients Columns * rcptid - this is a bigint sequential value which identifies the recipient uniquely in the database text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:logdb_sessions?rev=1542192349&do=diff LogDB.Sessions table The LogDB.Sessions table contains a record of all 'sessions' logged by VPOP3. A session is something like a POP3 server session as an email client downloads messages, or an SMTP client session as VPOP3 sends a message out to the Internet, and so on. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:logdb_spamrules?rev=1542192349&do=diff LogDB.SpamRules table The LogDB.SpamRules table contains a record of the spamfilter rules which matched for messages logged by VPOP3. A message may have zero or more spamrules entries Columns * spamruleid - this is a bigint sequential value which identifies the spam rule entry uniquely in the database text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:running_database_updates_within_a_transaction?rev=1542192349&do=diff Running database updates within a transaction This is a trick which database experts use, because they have learned (often the hard way) that a simple mistype can trash a database... Before running any database query which can alter the database (UPDATE, DELETE, INSERT, DROP, CREATE, ALTER) begin a database transaction using the text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamfilter_whitelist?rev=1542192349&do=diff Spamfilter.Whitelist table The Spamfilter.Whitelist table contains the spamfilter whitelist entries which do not contain wildcards or regular expressions. They are separated out to speed up checking. Columns * address - this is the email address in the whitelist text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_statement_dbqueryone?rev=1542192349&do=diff Spam Filter Rules: DBQueryOne Statement DBQueryOne Version 6.16+ Purpose Queries the spam filter database for a single record/aggregate The DBQueryOne statement performs a query on the spam filter database and returns a single value which is either the value of a record or an aggregate of several records. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:vpop3.postgresquery?rev=1542192349&do=diff VPOP3.PostgresQuery The Lua function 'VPOP3.PostgresQuery' performs a query on the PostgreSQL database and returns the results in a table It takes a single parameter which is the SQL query to perform (Note that any relations used in the query must have the schema specified). text/html 2026-03-16T16:00:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/wiki:syntax?rev=1773676810&do=diff Formatting Syntax DokuWiki supports some simple markup language, which tries to make the datafiles to be as readable as possible. This page contains all possible syntax you may use when editing the pages. Simply have a look at the source of this page by pressing