Fulltext results:
- Repairing corrupted database
- efore restarting VPOP3. =====Finding the problem table/index===== Often the error message will say somet... tallation to another. To determine which database table/index the relation refers to, follow these instru... aste) select n.nspname AS schema, c.relname AS tablename, c.relkind as kind from pg_class c inner join... fix the problem. If it is 'r' then it is a normal table, or if it is 't' then it is a 'toast' table (see
- VPOP3 Database Size
- the first place to look is to see which database tables are using the most space. To do this, go to th... press **Do Query**. This will show the biggest 20 tables in the database, and how much space they are occ... elation_size(C.oid) DESC LIMIT 20; Some of the tables which are commonly large are: * messages.msgd... n index for archived messages * logdb.* - these tables contain data for the 'historical logging & repor
- Move the message store - alternative method
- VPOP3\pgsql\data folder, but the actual database tables & indexes are stored in the new location. This m... tp://www.postgresql.org/docs/9.1/static/manage-ag-tablespaces.html|Tablespaces]]' To do this: - [[stop VPOP3]] - [[backup_vpop3#manual_database_backup|Bac... lt password here is 'pgsqlpass' - Type ''CREATE TABLESPACE vpop3ts OWNER vpop3 LOCATION 'd:\vpop3data'
- Delete OutQueue messages directly from the database
- d later to start as it check the message database tables for consistency during initialisation. In this ... eue CASCADE;'' This will delete all the relevant tables from the database, including their contents, so ... en you restart VPOP3 it will recreate the deleted tables. You cannot selectively delete messages in this
- Some PCs cannot access VPOP3 when VPOP3 is connected to the Internet
- or this is to correctly set up the TCP/IP routing table on the VPOP3 computer. Simply setting the TCP/IP ... The easiest way to explain how to set the routing table is by use of an example. Assume that the VPOP3 co
- VPOP3 cannot access PostgreSQL - timeout expired
- ne cause we have found is if the **pg_attribute** table in the database is too large. A known problem wit... greSQL shipped with VPOP3 (9.1.1) is that if this table is very large, it may take an exceptionally long
- Calendars
- 'Tools -> Settings -> Calendars''. The following table details how to perform key tasks in versions 4 an
- How to make VPOP3 re-download POP3 messages from the ISP
- Get' box for them. (Or check the 'Get' box in the table header to get all the messages). If you have VPO
- Performance Requirements
- many small updates are made, such as to database tables** =====Examples===== ====Low Requirements====
- Restore selected mail folders or mailbox in VPOP3 v5 or later
- choose the appropriate mailboxes/folders from the table. You can choose where to restore the messages - i
- How To Upgrade VPOP3
- is not critical) and have VPOP3 just create blank tables instead of importing the old data. To do this, t
