This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
how_to:v5_-_move_to_a_new_pc [2013/09/18 09:28] – [If you had previously installed VPOP3 on the new computer] paul | how_to:v5_-_move_to_a_new_pc [2023/02/08 10:48] (current) – [Backup the database] paul | ||
---|---|---|---|
Line 14: | Line 14: | ||
Please make sure you follow these instructions in the correct order. Many problems with moving installations are because people have thought we have got it wrong, and so do things in a different (incorrect) order. | Please make sure you follow these instructions in the correct order. Many problems with moving installations are because people have thought we have got it wrong, and so do things in a different (incorrect) order. | ||
- | If you want, we can do this move for you via remote access. The charge for us to do that is currently [[http:// | + | If you want, we can do this move for you via remote access. The charge for us to do that is currently [[https:// |
You can follow most of these steps if VPOP3 was on a PC that died, and you are moving it to a replacement PC. However, this is less ideal than [[restore_a_backup_of_vpop3|restoring from the latest daily backup]] you made. If you were not previously backing up VPOP3, this may be a [[http:// | You can follow most of these steps if VPOP3 was on a PC that died, and you are moving it to a replacement PC. However, this is less ideal than [[restore_a_backup_of_vpop3|restoring from the latest daily backup]] you made. If you were not previously backing up VPOP3, this may be a [[http:// | ||
Line 22: | Line 22: | ||
=====Backup the database===== | =====Backup the database===== | ||
To backup the database, go to a command prompt on the VPOP3 computer, and go to the VPOP3 directory. Then run | To backup the database, go to a command prompt on the VPOP3 computer, and go to the VPOP3 directory. Then run | ||
- | pgsql\bin\pg_dump -F c -p 5433 -U vpop3 -f database.dmp | + | pgsql\bin\pg_dump -F c -p 5433 -v -U vpop3 -f database.dmp |
//Note: the above line (and all subsequent database command lines on this page) assume port 5433 is being used. This will work in the majority of cases, but in certain circumstances, | //Note: the above line (and all subsequent database command lines on this page) assume port 5433 is being used. This will work in the majority of cases, but in certain circumstances, | ||
At the password prompt, type **vpop3pass** | At the password prompt, type **vpop3pass** | ||
- | (This assumes a standard installation, | + | (This assumes a standard installation, |
This will create a file ' | This will create a file ' | ||
Line 46: | Line 46: | ||
* If you are wanting to install a later version of VPOP3 as well as moving VPOP3, then at this step you would install the later version rather than the original version. | * If you are wanting to install a later version of VPOP3 as well as moving VPOP3, then at this step you would install the later version rather than the original version. | ||
=====Restore the Database Backup===== | =====Restore the Database Backup===== | ||
- | On the new PC, open up a command prompt and go to the VPOP3 directory. Then run | + | First, **delete the DBCHANGES.DAT file** from the VPOP3 directory (if it exists). This contains settings changes wanted by the installer, but they will overwrite the restored data, so you do not want them to take effect in this scenario. |
+ | |||
+ | Then, on the new PC, open up a command prompt and go to the VPOP3 directory. Then run | ||
pgsql\bin\pg_restore -p 5433 -U postgres -C -v -d postgres database.dmp | pgsql\bin\pg_restore -p 5433 -U postgres -C -v -d postgres database.dmp |