Differences

This shows you the differences between two versions of the page.

--- how_to:database_maintenance [2011/03/08 18:03] – [Rebuilding Indexes] 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 'clusterdb' program, so, from a command prompt, go to the VPOP3\pgsql\bin folder, and run **clusterdb -U vpop3 vpop3**. The default password is **vpop3pass**. This operation may take some time, and VPOP3 can't run while it is doing it. Also, the 'clusterdb' program may require a lot of free disk space while it is running, although it will use less when it has finished. (It creates a new copy of the table while it is running).
-If you are very short of free disk space, then you can use the 'vacuumdb' program, but this is not recommended except as a last resort. To do this, run **vacuumdb -f -U vpop3 vpop3**. After you have run this you will need to reindex the database as well - use **reindexdb -U vpop3**. This "vacuum full" operation will generally take a lot longer than the 'clusterdb' program.
+If you are very short of free disk space, then you can use the 'vacuumdb' program, but this is not recommended except as a last resort. To do this, run **vacuumdb -f -U vpop3 vpop3**. After you have run this you will need to reindex the database as well - use **reindexdb -U vpop3 vpop3**. This "vacuum full" operation will generally take a lot longer than the 'clusterdb' program.
 =====Rebuilding Indexes=====

PSCS Wiki