how_to:database_maintenance
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| how_to:database_maintenance [2013/09/09 10:16] – [Freeing disk space] paul | how_to:database_maintenance [2018/11/14 10:45] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 27: | Line 27: | ||
| * Stop the VPOP3 service, //not// the VPOP3DB service | * Stop the VPOP3 service, //not// the VPOP3DB service | ||
| * Go to a command prompt in the VPOP3 directory | * Go to a command prompt in the VPOP3 directory | ||
| - | * Backup the database to a file, eg ' | + | * Backup the database to a file, eg ' |
| - | * Remove the old database using **pgsql\bin\dropdb -U postgres -p 5433** | + | * Make sure there were no errors reported during the backup! |
| - | * Restore the database backup using, eg: **pgsql\bin\pg_restore | + | * Remove the old database using **pgsql\bin\dropdb -U postgres -p 5433 vpop3** |
| + | * Restore the database backup using, eg: **pgsql\bin\pg_restore -v -j 4 -U postgres -p 5433 -C -d postgres database.dmp** | ||
| * Restart the VPOP3 service | * Restart the VPOP3 service | ||
| Line 41: | Line 42: | ||
| ====Alternative to backup/ | ====Alternative to backup/ | ||
| - | 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. | ||
how_to/database_maintenance.1378718196.txt.gz · Last modified: 2018/11/14 10:44 (external edit)
Page Tools
