User Tools

Site Tools


how_to:v5_-_move_to_a_new_pc

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
how_to:v5_-_move_to_a_new_pc [2013/01/11 15:37] – [Install VPOP3 on the new PC] paulhow_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://www.pscs.co.uk/buynow/buy.php?item=ASSTMOVE|£30 (+ VAT)]]. If you want us to do this, make sure that it is possible to copy files between the PCs on your network (or have copied all the necessary files beforehand). Copying the files over the Internet to our office and then back again is not feasible given the large amounts of data that can be present.+If you want, we can do this move for you via remote access. The charge for us to do that is currently [[https://www.pscs.co.uk/buy/ASSTMOVE|£50 (+ VAT)]]. If you want us to do this, make sure that it is possible to copy files between the PCs on your network (or have copied all the necessary files beforehand). Copying the files over the Internet to our office and then back again is not feasible given the large amounts of data that can be present.
  
 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://www.pscs.co.uk/products/bfw/index.php|good time to start]]... 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://www.pscs.co.uk/products/bfw/index.php|good time to start]]...
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 vpop3
 //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, a different port number may be required.// //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, a different port number may be required.//
  
 At the password prompt, type **vpop3pass** At the password prompt, type **vpop3pass**
-(This assumes a standard installation, if your PostgreSQL installation is non-standard, then you may need to change this command appropriately)+(This assumes a standard installation, if your PostgreSQL installation is non-standard, then you may need to change this command appropriately). Note that for security reasons, the password will not be displayed as you type it in.
  
 This will create a file 'database.dmp' containing a backup of the database in the VPOP3 directory so it will be copied by the next step This will create a file 'database.dmp' containing a backup of the database in the VPOP3 directory so it will be copied by the next step
Line 41: Line 41:
 Install VPOP3 on the new PC as normal, but: Install VPOP3 on the new PC as normal, but:
   * Make sure you install into the same directory that you copied the VPOP3 directory tree to, so if you copied it to D:\VPOP3, make sure you install to D:\VPOP3. Most problems with moving VPOP3 are because this step is not followed correctly.   * Make sure you install into the same directory that you copied the VPOP3 directory tree to, so if you copied it to D:\VPOP3, make sure you install to D:\VPOP3. Most problems with moving VPOP3 are because this step is not followed correctly.
-  * If the installer asks you to enter your licence key, you do not need to do so, as the licence key will be recovered when you restore the database later in the process. However, make sure you choose the correct edition of VPOP3 - VPOP3 Basic or VPOP3 Enterprise+  * If the installer asks you to enter your licence key, you should enter it here. If you do not enter it, make sure you choose the correct edition of VPOP3 - VPOP3 Basic or VPOP3 Enterprise
   * During the component selection stage of the installation, make sure you **check** the 'Database Server for VPOP3' option. Sometimes this will not be checked by default during a move operation   * During the component selection stage of the installation, make sure you **check** the 'Database Server for VPOP3' option. Sometimes this will not be checked by default during a move operation
   * At the end of the install, make sure you **uncheck** the **Start VPOP3** option, so that VPOP3 does not run   * At the end of the install, make sure you **uncheck** the **Start VPOP3** option, so that VPOP3 does not run
 +  * 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 PCopen 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.
  
-  pgsql\bin\pg_restore -p 5433 -U postgres -d vpop3 database.dmp+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
  
 At the password prompt, enter ''pgsqlpass'' At the password prompt, enter ''pgsqlpass''
Line 67: Line 69:
 In this case, you will need to create the VPOP3 database again during the restore: In this case, you will need to create the VPOP3 database again during the restore:
  
-  pgsql\bin\pg_restore -p 5433 -U postgres -C -d postgres database.dmp +  pgsql\bin\pg_restore -p 5433 -U postgres -C -v -d postgres database.dmp
- +
-(note the change from the normal restore procedure from ''-d vpop3'' to ''-d postgres'')+
  
 At the command prompt, enter ''pgsqlpass'' At the command prompt, enter ''pgsqlpass''
 +
 +====Moving installation directory====
 +If you are installing VPOP3 in a different directory on the new PC than it was on the old PC, you need to change some settings.
 +
 +This needs a little utility. You can download it from http://www.pscs.co.uk/downloads/vpop3settings.zip . Download this file, and extract the contents into the new VPOP3 installation directory
 +
 +At a command prompt, find the VPOP3 installation directory and run
 +  vpop3settings replacepaths <old path> <new path>
 +  
 +e.g. Run
 +  vpop3settings replacepaths c:\vpop3 d:\vpop3
 +  
 +The utility will display all the settings which used the old location and ask if you want to change them to the new location. Check the settings, and press 'Y' if they are correct
  
  
how_to/v5_-_move_to_a_new_pc.1357918636.txt.gz · Last modified: 2018/11/14 10:44 (external edit)