how_to:database_maintenance
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
| how_to:database_maintenance [2014/03/31 13:19] – [Steps for backup/restore] paul | how_to:database_maintenance [2018/04/17 15:33] – [Steps for backup/restore] paul | ||
|---|---|---|---|
| Line 28: | Line 28: | ||
| * 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 ' | ||
| + | * Make sure there were no errors reported during the backup! | ||
| * Remove the old database using **pgsql\bin\dropdb -U postgres -p 5433 vpop3** | * 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** | * Restore the database backup using, eg: **pgsql\bin\pg_restore -v -j 4 -U postgres -p 5433 -C -d postgres database.dmp** | ||
how_to/database_maintenance.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1
Page Tools
