• skip to content

PSCS Wiki

User Tools

  • Admin
  • Log In

Site Tools

  • Recent Changes
  • Media Manager
  • Sitemap
Trace:

database

Search

You can find the results of your search below.

Exact match
  • Exact match
  • Starts with
  • Ends with
  • Contains
Any namespace
  • Any namespace
  • reference (72)
  • how_to (62)
  • adminapi (7)
  • faq (3)
  • fatal (1)
  • wiki (1)
Any time
  • Any time
  • Past week
  • Past month
  • Past year
Sort by hits
  • Sort by hits
  • Sort by last modified

Matching pagenames:

  • Database Backup Failed
  • Database & Disk Caching
  • Database Issues
  • Database Maintenance
  • VPOP3 Database Size
  • Delete OutQueue messages directly from the database
  • How to estimate Database Upgrade Time
  • handling_database_backups
  • Install VPOP3 using external PostgreSQL database
  • How to install PostgreSQL to use another port
  • Manually installing the PostgreSQL Database Server
  • Repairing corrupted database
  • Restore a database backup
  • Software conflicting with database service
  • Total Rebuild of Database
  • Upgrading PostgreSQL Database Software
  • 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
  • Batch file to end a database backup
  • Calendar database schema
  • Copy SMTP Rules - Database Query
  • Settings -> Database
  • Database -> Backups Tab
  • Database files used in VPOP3 2.x
  • Database -> Message Store Tab
  • Database -> Restore Tab
  • Database schema used in VPOP3 5.x
  • Users database schema
  • Database query to export LAN Forwarding rules
  • Database query to find forwards/assistants etc in user settings
  • Database query to get all lists and members
  • Database query to list ALL messages in the LAN forwarding queue
  • Database query to list failed message sends
  • Database query to list messages in the LAN forwarding queue waiting to go to a specific server
  • LogDB database schema
  • loginaudit Database table
  • Database query to make LAN Forwarding immediately attempt to dequeue all pending messages
  • msgaudit Database table
  • Running database updates within a transaction
  • SMTPStats database schema
  • Spamfilter database comparators
  • Useful Database Queries
  • Database query to view password change history

Fulltext results:

VPOP3 Not Starting Properly @how_to
27 Hits, Last modified: 7 years ago
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: 7 years ago
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
21 Hits, Last modified: 17 months ago
======Repairing corrupted database====== With PostgreSQL (as with most high-end databases) the database system will automatically recover after power fai... ommon causes for unrecoverable data errors are: [[database_issues#disk_caching|incorrect disk caching]], [[database_issues#possible_conflicting_software|virus scanner
Restore a database backup @how_to
19 Hits, Last modified: 21 months ago
======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: 9 months ago
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
Move VPOP3 Version 3 or 4 to a new PC @how_to
18 Hits, Last modified: 6 years ago
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: 7 years ago
======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: 4 years ago
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
What is PostgreSQL? @faq
17 Hits, Last modified: 7 years ago
[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 ... n VPOP3 3.x, we have moved the message store to a database to improve performance and reliability. We decide
How to Restore a backup of VPOP3 @how_to
16 Hits, Last modified: 7 years ago
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: 7 years ago
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: 7 years ago
======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: 7 years ago
======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: 7 years ago
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: 7 years ago
======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: 6 years ago
How to move the VPOP3 Message Store to a new PC @how_to
12 Hits, Last modified: 7 years ago
How to upgrade VPOP3 to version 7 or later from version 6 or earlier @how_to
12 Hits, Last modified: 5 years ago
Total Rebuild of Database @how_to
11 Hits, Last modified: 7 years ago
VPOP3 Historical Logger Backlog @how_to
11 Hits, Last modified: 7 years ago
Database -> Backups Tab @reference
11 Hits, Last modified: 7 years ago
Upgrading VPOP3 to version 8.x from v7 or earlier @how_to
10 Hits, Last modified: 5 years ago
FATAL: connection limit exceeded for non-superusers @fatal
10 Hits, Last modified: 7 years ago
Running database updates within a transaction @reference
10 Hits, Last modified: 7 years ago
PostgreSQL server won't start due to damaged log files @how_to
9 Hits, Last modified: 7 years ago
Move the message store - alternative method @how_to
8 Hits, Last modified: 7 years ago
Settings -> Database @reference
8 Hits, Last modified: 7 years ago
Database -> Message Store Tab @reference
8 Hits, Last modified: 7 years ago
How to estimate Database Upgrade Time @how_to
8 Hits, Last modified: 7 years ago
Restore Deleted Calendars @how_to
7 Hits, Last modified: 3 years ago
Delete OutQueue messages directly from the database @how_to
7 Hits, Last modified: 7 years ago
Logging @reference
7 Hits, Last modified: 7 years ago
Exceptions @how_to
6 Hits, Last modified: 7 years ago
Database schema used in VPOP3 5.x @reference
6 Hits, Last modified: 7 years ago
Reset Message Folder Counts @reference
6 Hits, Last modified: 7 years ago
POP3/Webmail/IMAP4 can't see a user's messages, but the administrator can @how_to
6 Hits, Last modified: 7 years ago
v5 - Move the message store to a new folder/drive @how_to
5 Hits, Last modified: 6 years ago
v3/4 - Move the message store to a new folder/drive @how_to
5 Hits, Last modified: 7 years ago
Database files used in VPOP3 2.x @reference
5 Hits, Last modified: 7 years ago
Database query to alter LAN Forwarding rules for one server to go to another @reference
5 Hits, Last modified: 7 years ago
Upgrading PostgreSQL Database Software @how_to
5 Hits, Last modified: 7 years ago
Database query to alter LAN Forwarding rules for one server to go to another @reference
5 Hits, Last modified: 7 years ago
How to install PostgreSQL to use another port @how_to
5 Hits, Last modified: 7 years ago
Performance Requirements @how_to
5 Hits, Last modified: 7 years ago
Installation checklist @how_to
5 Hits, Last modified: 7 years ago
Database & Disk Caching @how_to
5 Hits, Last modified: 7 years ago
Database Backup Failed @how_to
5 Hits, Last modified: 7 years ago
Lua Scripting @reference
4 Hits, Last modified: 2 days ago
Installation Errors @how_to
4 Hits, Last modified: 7 years ago
Install VPOP3 using external PostgreSQL database @how_to
4 Hits, Last modified: 7 years ago
"How To" Articles @how_to
4 Hits, Last modified: 3 years ago
PostgreSQL Replication @how_to
4 Hits, Last modified: 6 years ago
How to remove messages from the outbound queue @how_to
3 Hits, Last modified: 7 years ago
Calendar.Events table @reference
3 Hits, Last modified: 7 years ago
LogDB database schema @reference
3 Hits, Last modified: 7 years ago
SMTPClientBlocks Replacement @adminapi
3 Hits, Last modified: 7 years ago
Batch file to end a database backup @reference
3 Hits, Last modified: 7 years ago
Calendar database schema @reference
3 Hits, Last modified: 7 years ago
Useful Database Queries @reference
3 Hits, Last modified: 4 years ago
How To Upgrade VPOP3 @how_to
3 Hits, Last modified: 7 years ago
Spam Filter Rules: DBQueryOne @reference
3 Hits, Last modified: 7 years ago
VPOP3 Internals @reference
2 Hits, Last modified: 22 months ago
msgaudit Database table @reference
2 Hits, Last modified: 7 years ago
Database query to find forwards/assistants etc in user settings @reference
2 Hits, Last modified: 7 years ago
Database query to list ALL messages in the LAN forwarding queue @reference
2 Hits, Last modified: 7 years ago
Message Archive @reference
2 Hits, Last modified: 7 years ago
Database query to list messages in the LAN forwarding queue waiting to go to a specific server @reference
2 Hits, Last modified: 7 years ago
Copy SMTP Rules - Database Query @reference
2 Hits, Last modified: 7 years ago
Users database schema @reference
2 Hits, Last modified: 7 years ago
Database query to make LAN Forwarding immediately attempt to dequeue all pending messages @reference
2 Hits, Last modified: 7 years ago
SMTPStats database schema @reference
2 Hits, Last modified: 7 years ago
Access Restrictions Internal Format @reference
2 Hits, Last modified: 22 months ago
Spam Filter Rules: AddBayesHam @reference
2 Hits, Last modified: 7 years ago
Spamfilter -> General @reference
2 Hits, Last modified: 7 years ago
Software conflicting with database service @how_to
2 Hits, Last modified: 7 years ago
User Advanced settings @reference
2 Hits, Last modified: 7 years ago
Alternative method of automatically starting VPOP3 @how_to
2 Hits, Last modified: 7 years ago
VPOP3 re-downloading old messages from the ISP POP3 server @how_to
2 Hits, Last modified: 7 years ago
Spam Filter Rules: RemoveBayesSpam @reference
2 Hits, Last modified: 7 years ago
Spam Filter Rules: RemoveBayesHam @reference
2 Hits, Last modified: 7 years ago
Many instances of Postgres.exe are running @how_to
2 Hits, Last modified: 7 years ago
Full Text Search @how_to
2 Hits, Last modified: 7 years ago
Spam Filter Rules: AddBayesSpam @reference
2 Hits, Last modified: 7 years ago
How to move VPOP3 V3 to a new folder @how_to
2 Hits, Last modified: 7 years ago
VPOP3 2.x crashes when user tries to download mail @how_to
2 Hits, Last modified: 7 years ago
Spam Filter Rules: DBDeleteTime @reference
1 Hits, Last modified: 7 years ago
Spamfilter database comparators @reference
1 Hits, Last modified: 7 years ago
VPOP3.SetSetting @reference
1 Hits, Last modified: 4 years ago
SMTP Server Lua Scripting @reference
1 Hits, Last modified: 3 weeks ago
VPOP3.PostgresQuery @reference
1 Hits, Last modified: 7 years ago
VPOP3.GetSetting @reference
1 Hits, Last modified: 7 years ago
Database query to view password change history @reference
1 Hits, Last modified: 7 years ago
Users.Users table @reference
1 Hits, Last modified: 7 years ago
Prune Rules @reference
1 Hits, Last modified: 7 years ago
Spam Filter Rules: Assignments @reference
1 Hits, Last modified: 7 years ago
Password Lengths @reference
1 Hits, Last modified: 4 years ago
Outgoing Message Scripting @reference
1 Hits, Last modified: 15 months ago
Spam Filter Rules: DBInsert @reference
1 Hits, Last modified: 7 years ago
public @reference
1 Hits, Last modified: 22 months ago
Useful other things @reference
1 Hits, Last modified: 7 years ago
VPOP3 Reference @reference
1 Hits, Last modified: 7 years ago
Spam Filter Rules: Variables @reference
1 Hits, Last modified: 22 months ago
Settings @reference
1 Hits, Last modified: 7 years ago
SMTP Reputation Stats @reference
1 Hits, Last modified: 7 years ago
Spam Filter Rules: DBUpdate @reference
1 Hits, Last modified: 7 years ago
loginaudit Database table @reference
1 Hits, Last modified: 22 months ago
SMTPClientAllowAdd Action @adminapi
1 Hits, Last modified: 7 years ago
LogDB.SpamRules table @reference
1 Hits, Last modified: 7 years ago
C++ Error Popup @how_to
1 Hits, Last modified: 7 years ago
Timeout while VPOP3DB is starting @how_to
1 Hits, Last modified: 7 years ago
Router Problem error messages @how_to
1 Hits, Last modified: 7 years ago
How to move messages between users @how_to
1 Hits, Last modified: 7 years ago
How To: Move VPOP3 @how_to
1 Hits, Last modified: 6 years ago
Manually installing the PostgreSQL Database Server @how_to
1 Hits, Last modified: 7 years ago
Localhost missing from Vista HOSTS file @how_to
1 Hits, Last modified: 7 years ago
Error Messages @how_to
1 Hits, Last modified: 2 years ago
VPOP3 Webmail/admin service and/or Status service is not listening on correct IP addresses or ports @how_to
1 Hits, Last modified: 7 years ago
Undelete Messages in VPOP3 Enterprise v5 or later @how_to
1 Hits, Last modified: 7 years ago
450 4.3.2 Content Filter Timeout @how_to
1 Hits, Last modified: 7 years ago
What is the difference between VPOP3 Basic and VPOP3 Enterprise? @faq
1 Hits, Last modified: 7 years ago
GDPR for other hosting services (eg web hosting) @faq
1 Hits, Last modified: 7 years ago
SMTPIDSEvents Replacement @adminapi
1 Hits, Last modified: 7 years ago
SMTPClientBlockRemove Action @adminapi
1 Hits, Last modified: 7 years ago
SMTPClientBlockAdd Action @adminapi
1 Hits, Last modified: 7 years ago
SMTPClientAllows Replacement @adminapi
1 Hits, Last modified: 7 years ago
Video Tutorials @how_to
1 Hits, Last modified: 7 years ago
VPOP3 Antivirus Update Error - Error 55 @how_to
1 Hits, Last modified: 7 years ago
LogDB.Sessions table @reference
1 Hits, Last modified: 7 years ago
Database query to get all lists and members @reference
1 Hits, Last modified: 7 years ago
LogDB.Recipients table @reference
1 Hits, Last modified: 7 years ago
LogDB.Messages table @reference
1 Hits, Last modified: 7 years ago
LogDB.Attachments table @reference
1 Hits, Last modified: 7 years ago
Lists @reference
1 Hits, Last modified: 7 years ago
Database query to list failed message sends @reference
1 Hits, Last modified: 7 years ago
LDAP Schema in VPOP3 4.x @reference
1 Hits, Last modified: 7 years ago
Internal Data Formats @reference
1 Hits, Last modified: 22 months ago
Find a message @reference
1 Hits, Last modified: 7 years ago
VPOP3 cannot access PostgreSQL - timeout expired @how_to
1 Hits, Last modified: 7 years ago
Find biggest messages @reference
1 Hits, Last modified: 6 years ago
Database query to export LAN Forwarding rules @reference
1 Hits, Last modified: 7 years ago
Error Handling Scripting @reference
1 Hits, Last modified: 19 months ago
Delete list member from all lists @reference
1 Hits, Last modified: 7 years ago
Calendar.Calendars table @reference
1 Hits, Last modified: 7 years ago
SMTPClientAllowRemove Action @adminapi
1 Hits, Last modified: 7 years ago
VPOP3DB Service doesn't exist @how_to
1 Hits, Last modified: 7 years ago
DokuWiki @wiki
1 Hits, Last modified: 3 years ago

Page Tools

  • Show page
  • Old revisions
  • Backlinks
  • Back to top
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki