how_to:database_maintenance
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revisionNext revisionBoth sides next revision | ||
| how_to:database_maintenance [2011/01/14 12:45] – created paul | how_to:database_maintenance [2011/03/08 18:03] – [Freeing disk space] paul | ||
|---|---|---|---|
| Line 15: | Line 15: | ||
| The main program you should use for decreasing the size of the database is the ' | The main program you should use for decreasing the size of the database is the ' | ||
| - | If you are very short of free disk space, then you can use the ' | + | If you are very short of free disk space, then you can use the ' |
| =====Rebuilding Indexes===== | =====Rebuilding Indexes===== | ||
| If you suspect that indexes have become damaged, then you can reindex the database. Again, this requires VPOP3 to be stopped first. | If you suspect that indexes have become damaged, then you can reindex the database. Again, this requires VPOP3 to be stopped first. | ||
| - | Go to the VPOP3\pgsql\bin folder in a Windows command prompt. Then run **reindexdb -U vpop3**. The default password is **vpop3pass**. This operation may take a while, and require some free disk space. | + | Go to the VPOP3\pgsql\bin folder in a Windows command prompt. Then run **reindexdb -U vpop3 vpop3**. The default password is **vpop3pass**. This operation may take a while, and require some free disk space. |
how_to/database_maintenance.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1
Page Tools
