PSCS Wiki

User Tools

Site Tools

Trace:
database

Search

You can find the results of your search below.

Matching pagenames:

Fulltext results:

VPOP3 Not Starting Properly @how_to
29 Hits, Last modified:
rly, then the first thing to check is whether the database server is starting. In VPOP3 v3 and later, VPOP3 uses a [[http://www.postgresql.org|PostgreSQL]] Database server for data storage, so if the database server is not running, VPOP3 will not be able to start properly... s. If this is not running, then start it. If the database service does not exist, see the [[VPOP3DB service
How to Backup VPOP3 @how_to
24 Hits, Last modified:
will automatically perform a daily backup of the database into a file called DBBACK-x.DMP, where the backup... nday's backup, etc). In VPOP3 v5 and later, this database backup is a full backup of VPOP3. In VPOP3 v3 & v... up other files/data as well. See our "[[Handling Database Backups]]" article for some hints/tips for the au... tory tree. Make sure you backup the **[[reference:database|DBBack-<number>.DMP]]** files, these contain the
Repairing corrupted database @how_to
22 Hits, Last modified:
======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 ther... ommon causes for unrecoverable data errors are: [[database_issues#disk_caching|incorrect disk caching]], [[d
Restore a database backup @how_to
19 Hits, Last modified:
======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 [[reference:database backups|change this in the settings]]). These are... ays' worth of backups. These can be useful if the database gets damaged somehow. If you have a valid backup
Move VPOP3 Version 5 (or later) to a new PC @how_to
19 Hits, Last modified:
e VPOP3|moving earlier versions]], because of the database system, which was introduced for version 3 and mo... the original PC - Manually make a backup of the database on the original PC - Copy the VPOP3 directory t... C, **but do not start VPOP3 yet** - Restore the database backup (from step 2) on the new PC - Check sett... [stop VPOP3]] on the original PC =====Backup the database===== To backup the database, go to a command prom
What is PostgreSQL? @faq
19 Hits, Last modified:
[http://www.postgresql.org|PostgreSQL]] is an SQL database engine. =====VPOP3 and PostgreSQL===== In VPOP3 2.x, VPOP3 uses a database engine called [[http://www.sqlite.org|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 l
Move VPOP3 Version 3 or 4 to a new PC @how_to
18 Hits, Last modified:
e VPOP3|moving earlier versions]], because of the database system. The summary of steps is: - Stop VPOP3 ... the original PC - Manually make a backup of the database on the original PC - Copy the VPOP3 directory t... C, **but do not start VPOP3 yet** - Restore the database backup (from step 2) on the new PC - Reset some... [stop VPOP3]] on the original PC =====Backup the database===== To backup the database, go to a command prom
Database Maintenance @how_to
18 Hits, Last modified:
======Database Maintenance====== VPOP3 uses the [[http://www.postgresql.org|PostgreSQL]] database server for most of its data storage. Normally th... because it will manage itself. To do any special database maintenance you will need to close down VPOP3 fir... because PostgreSQL needs exclusive access to the database to perform any operations such as decreasing the
How to Install VPOP3 @how_to
17 Hits, Last modified:
om Vista Hosts File]] * [[Installing PostgreSQL database on another port]] if another version of PostgreSQ... turn off disk **write-back** caching on your PC. Database systems require tight control of hard disks to av... en, the data will be lost, and this can cause the database to be corrupted. * You should definitely disab... l cause the PC to reboot, possibly corrupting the database. * You should consider disabling write-back cac
How to Restore a backup of VPOP3 @how_to
16 Hits, Last modified:
ion 5 or later===== If you just need to restore a database backup, see steps 4 to 7 below. To restore a [[b... tored VPOP3. This should reinstall the PostgreSQL database system. //Do not start VPOP3 at this time// - O... u are restoring the backup over an existing VPOP3 database (especially if the database files are damaged) you will need to //DROP// the database first. To do this, ru
Restore selected mail folders or mailbox in VPOP3 v5 or later @how_to
15 Hits, Last modified:
o do this First you need to find the appropriate database backup file. Usually VPOP3 makes daily database backups on a weekly cycle into the main VPOP3 installation ... u want to restore. Now, you need to restore this database file into a temporary PostgreSQL database. For the purposes of this article, we will assume you will be res
VPOP3 Database Size @how_to
15 Hits, Last modified:
======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
Database Issues @how_to
14 Hits, Last modified:
======Database Issues====== VPOP3 version 3 and later use the [[http://www.postgresql.org|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]] * [[S
VPOP3 is using a lot of disk space @how_to
14 Hits, Last modified:
and later, all users' messages are stored in the database, so they will occupy space in the VPOP3\pgsql\dat... 3 and 4, users' small messages are stored in the database, so will occupy space in the VPOP3\pgsql\data fol... arily reduce the amount of disk space used by the database. See the [[database_maintenance]] topic for more information. In VPOP3 versions 1 and 2, users' messages a
Database -> Restore Tab @reference
14 Hits, Last modified:
======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
How To Upgrade VPOP3 to version 5 or later @how_to
13 Hits, Last modified:
How to move the VPOP3 Message Store to a new PC @how_to
12 Hits, Last modified:
How to upgrade VPOP3 to version 7 or later from version 6 or earlier @how_to
12 Hits, Last modified:
Database -> Backups Tab @reference
11 Hits, Last modified:
VPOP3 Historical Logger Backlog @how_to
11 Hits, Last modified:
Total Rebuild of Database @how_to
11 Hits, Last modified:
Running database updates within a transaction @reference
10 Hits, Last modified:
Database files used in VPOP3 2.x @reference
10 Hits, Last modified:
Upgrading VPOP3 to version 8.x from v7 or earlier @how_to
10 Hits, Last modified:
FATAL: connection limit exceeded for non-superusers @fatal
10 Hits, Last modified:
PostgreSQL server won't start due to damaged log files @how_to
9 Hits, Last modified:
How to estimate Database Upgrade Time @how_to
9 Hits, Last modified:
Settings -> Database @reference
8 Hits, Last modified:
Database -> Message Store Tab @reference
8 Hits, Last modified:
Move the message store - alternative method @how_to
8 Hits, Last modified:
Restore Deleted Calendars @how_to
7 Hits, Last modified:
Delete OutQueue messages directly from the database @how_to
7 Hits, Last modified:
Logging @reference
7 Hits, Last modified:
Database schema used in VPOP3 5.x @reference
6 Hits, Last modified:
Exceptions @how_to
6 Hits, Last modified:
Database & Disk Caching @how_to
6 Hits, Last modified:
Reset Message Folder Counts @reference
6 Hits, Last modified:
POP3/Webmail/IMAP4 can't see a user's messages, but the administrator can @how_to
6 Hits, Last modified:
v5 - Move the message store to a new folder/drive @how_to
5 Hits, Last modified:
Upgrading PostgreSQL Database Software @how_to
5 Hits, Last modified:
Database query to alter LAN Forwarding rules for one server to go to another @reference
5 Hits, Last modified:
v3/4 - Move the message store to a new folder/drive @how_to
5 Hits, Last modified:
Database query to alter LAN Forwarding rules for one server to go to another @reference
5 Hits, Last modified:
Performance Requirements @how_to
5 Hits, Last modified:
How to install PostgreSQL to use another port @how_to
5 Hits, Last modified:
Installation checklist @how_to
5 Hits, Last modified:
Database Backup Failed @how_to
5 Hits, Last modified:
PostgreSQL Replication @how_to
4 Hits, Last modified:
Lua Scripting @reference
4 Hits, Last modified:
Installation Errors @how_to
4 Hits, Last modified:
Install VPOP3 using external PostgreSQL database @how_to
4 Hits, Last modified:
"How To" Articles @how_to
4 Hits, Last modified:
How to remove messages from the outbound queue @how_to
3 Hits, Last modified:
LogDB database schema @reference
3 Hits, Last modified:
SMTPClientBlocks Replacement @adminapi
3 Hits, Last modified:
Batch file to end a database backup @reference
3 Hits, Last modified:
VPOP3 2.x crashes when user tries to download mail @how_to
3 Hits, Last modified:
Calendar database schema @reference
3 Hits, Last modified:
Useful Database Queries @reference
3 Hits, Last modified:
Calendar.Events table @reference
3 Hits, Last modified:
How To Upgrade VPOP3 @how_to
3 Hits, Last modified:
Spam Filter Rules: DBQueryOne @reference
3 Hits, Last modified:
Database query to find forwards/assistants etc in user settings @reference
2 Hits, Last modified:
VPOP3 Internals @reference
2 Hits, Last modified:
msgaudit Database table @reference
2 Hits, Last modified:
Users database schema @reference
2 Hits, Last modified:
Database query to list ALL messages in the LAN forwarding queue @reference
2 Hits, Last modified:
Message Archive @reference
2 Hits, Last modified:
Database query to list messages in the LAN forwarding queue waiting to go to a specific server @reference
2 Hits, Last modified:
Copy SMTP Rules - Database Query @reference
2 Hits, Last modified:
Database query to make LAN Forwarding immediately attempt to dequeue all pending messages @reference
2 Hits, Last modified:
SMTPStats database schema @reference
2 Hits, Last modified:
Access Restrictions Internal Format @reference
2 Hits, Last modified:
Spam Filter Rules: AddBayesHam @reference
2 Hits, Last modified:
Spamfilter -> General @reference
2 Hits, Last modified:
Many instances of Postgres.exe are running @how_to
2 Hits, Last modified:
User Advanced settings @reference
2 Hits, Last modified:
Alternative method of automatically starting VPOP3 @how_to
2 Hits, Last modified:
VPOP3 re-downloading old messages from the ISP POP3 server @how_to
2 Hits, Last modified:
Full Text Search @how_to
2 Hits, Last modified:
Spam Filter Rules: RemoveBayesHam @reference
2 Hits, Last modified:
Spam Filter Rules: RemoveBayesSpam @reference
2 Hits, Last modified:
Software conflicting with database service @how_to
2 Hits, Last modified:
Spam Filter Rules: AddBayesSpam @reference
2 Hits, Last modified:
How to move VPOP3 V3 to a new folder @how_to
2 Hits, Last modified:
Outgoing Message Scripting @reference
1 Hits, Last modified:
VPOP3.SetSetting @reference
1 Hits, Last modified:
SMTP Server Lua Scripting @reference
1 Hits, Last modified:
VPOP3.PostgresQuery @reference
1 Hits, Last modified:
VPOP3.GetSetting @reference
1 Hits, Last modified:
Database query to view password change history @reference
1 Hits, Last modified:
Users.Users table @reference
1 Hits, Last modified:
Prune Rules @reference
1 Hits, Last modified:
Spamfilter Rule Weights @reference
1 Hits, Last modified:
Useful other things @reference
1 Hits, Last modified:
public @reference
1 Hits, Last modified:
Password Lengths @reference
1 Hits, Last modified:
Spam Filter Rules: DBDeleteTime @reference
1 Hits, Last modified:
Spam Filter Rules: Assignments @reference
1 Hits, Last modified:
VPOP3 Reference @reference
1 Hits, Last modified:
Spam Filter Rules: Variables @reference
1 Hits, Last modified:
Settings @reference
1 Hits, Last modified:
SMTP Reputation Stats @reference
1 Hits, Last modified:
Spamfilter database comparators @reference
1 Hits, Last modified:
Spam Filter Rules: DBUpdate @reference
1 Hits, Last modified:
Spam Filter Rules: DBInsert @reference
1 Hits, Last modified:
loginaudit Database table @reference
1 Hits, Last modified:
SMTPClientAllowAdd Action @adminapi
1 Hits, Last modified:
LogDB.SpamRules table @reference
1 Hits, Last modified:
VPOP3 Webmail/admin service and/or Status service is not listening on correct IP addresses or ports @how_to
1 Hits, Last modified:
Router Problem error messages @how_to
1 Hits, Last modified:
How to move messages between users @how_to
1 Hits, Last modified:
How To: Move VPOP3 @how_to
1 Hits, Last modified:
Manually installing the PostgreSQL Database Server @how_to
1 Hits, Last modified:
Localhost missing from Vista HOSTS file @how_to
1 Hits, Last modified:
Error Messages @how_to
1 Hits, Last modified:
C++ Error Popup @how_to
1 Hits, Last modified:
450 4.3.2 Content Filter Timeout @how_to
1 Hits, Last modified:
Video Tutorials @how_to
1 Hits, Last modified:
What is the difference between VPOP3 Basic and VPOP3 Enterprise? @faq
1 Hits, Last modified:
GDPR for other hosting services (eg web hosting) @faq
1 Hits, Last modified:
GDPR for hosted VPOP3 service @faq
1 Hits, Last modified:
SMTPIDSEvents Replacement @adminapi
1 Hits, Last modified:
SMTPClientBlockRemove Action @adminapi
1 Hits, Last modified:
SMTPClientBlockAdd Action @adminapi
1 Hits, Last modified:
SMTPClientAllows Replacement @adminapi
1 Hits, Last modified:
Timeout while VPOP3DB is starting @how_to
1 Hits, Last modified:
Undelete Messages in VPOP3 Enterprise v5 or later @how_to
1 Hits, Last modified:
LogDB.Sessions table @reference
1 Hits, Last modified:
Database query to get all lists and members @reference
1 Hits, Last modified:
LogDB.Recipients table @reference
1 Hits, Last modified:
LogDB.Messages table @reference
1 Hits, Last modified:
LogDB.Attachments table @reference
1 Hits, Last modified:
Lists @reference
1 Hits, Last modified:
Database query to list failed message sends @reference
1 Hits, Last modified:
LDAP Schema in VPOP3 4.x @reference
1 Hits, Last modified:
Internal Data Formats @reference
1 Hits, Last modified:
Find a message @reference
1 Hits, Last modified:
VPOP3 Antivirus Update Error - Error 55 @how_to
1 Hits, Last modified:
Find biggest messages @reference
1 Hits, Last modified:
Database query to export LAN Forwarding rules @reference
1 Hits, Last modified:
Error Handling Scripting @reference
1 Hits, Last modified:
Delete list member from all lists @reference
1 Hits, Last modified:
Calendar.Calendars table @reference
1 Hits, Last modified:
SMTPClientAllowRemove Action @adminapi
1 Hits, Last modified:
VPOP3DB Service doesn't exist @how_to
1 Hits, Last modified:
VPOP3 cannot access PostgreSQL - timeout expired @how_to
1 Hits, Last modified:
DokuWiki @wiki
1 Hits, Last modified:

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki