Fulltext results:
- Database -> Restore Tab
- ======Database -> Restore Tab====== This tab is only in VPOP3 Enterprise (v5 and later), and is for performi... ng a partial (mailbox/mail folder) restore of the database. To do a full restore of the database, or for VPOP3 Basic/Standard, see the "[[how_to:restore_a_backup_of_v... en deleted within the last few days. To use this database restore facility, first you need to restore a dat
- Database -> Backups Tab
- ======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.... backup feature, or manually backup the PostgreSQL database using the pg_dump command, or use another program
- Running database updates within a transaction
- ======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, A
- Database files used in VPOP3 2.x
- ======Database files used in VPOP3 2.x====== VPOP3 2.x usually uses SQLite 2.8.3 as its database engine. This stores databases in discrete *.db files in the VPOP3\_database directory on the server PC. We do not recommend that you acc
- Settings -> Database
- ======Settings -> Database====== The **Settings -> Database** page lets you configure the use of the back-end database which VPOP3 uses for configuration data, message storage and other uses. =====Tabs===== * [[Database Backups|Backups]] * [[Database Query|Query]]
- Database -> Message Store Tab
- ======Database -> Message Store Tab====== This tab says how VPOP3 handles its message store =====Message St... VPOP3 how quickly to import messages into the new database structure if it was upgraded from version 2.x or ... 2 message store and other messages are in the new database store. However, during this time, the database backups will not contain all your data, so you should [[how
- Logging
- o keep the data for before it is removed from the database. (Once it has been removed from the database it cannot be recovered, unless you have a database backup) =====Log Database Status===== The Log Database Status section contains information about the **His
- Database schema used in VPOP3 5.x
- ======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 u... information at your own risk. //Do not alter the database schema used by VPOP3 (including indexes, triggers... /release-8-3-15.html|8.3]] or later. The default database name used by VPOP3 is 'vpop3', the default userna
- Reset Message Folder Counts
- rare cases, the mail folder message counts in the database may get out of step with the actual stored messages. There are database triggers which will keep the counts in sync durin... rmal operation, but if you have to manipulate the database directly (eg to recover from a corrupted database) it is possible that they will get out of step. **Before
- Database query to alter LAN Forwarding rules for one server to go to another
- ======Database query to alter LAN Forwarding rules for one server to go to another====== If a LAN forwardin... iated with the server host name instead) As this database query updates the database, be sure to take care doing it as you can damage your VPOP3 installation if you do it incorrectly. Make sure you have a database backup before performing the query. If you want
- Database query to alter LAN Forwarding rules for one server to go to another
- ======Database query to alter LAN Forwarding rules for one server to go to another====== If a LAN forwardin... iated with the server host name instead) As this database query updates the database, be sure to take care doing it as you can damage your VPOP3 installation if you do it incorrectly. Make sure you have a database backup before performing the query. If you want
- Lua Scripting
- 3 v6.7 and later, scripts are stored in the VPOP3 database, and are managed from the Settings -> Scripts pag... he VPOP3 directory, VPOP3 will import it into the database on first use. * [[Archive Script|Archive Scrip... oresponder Script|Autoresponder Scripting]] * [[Database Backup Script|Database Backup Scripting]] * [[DMARC Reporter Script|DMARC Reporter Scripting]] * [[Erro
- Calendar database schema
- ======Calendar database schema====== The Calendar database schema contains the data for the Calendar/CalDAV component of VPOP3. No... data is stored in iCalendar/.ics file format. The database just stores information for helping with selectiv
- Batch file to end a database backup
- ======Batch file to end a database backup====== VPOP3 runs pg_dump.exe to perform the regular database backups. Ending this process through Task Manager will not end the back-end database processes creating the backup data. This batch fi
- LogDB database schema
- ======LogDB database schema====== The LogDB database schema contains historical logging information for reports etc. Entries are... reporting' section uses the data here. The LogDB database is only populated if the '[[logging#historical_lo
