User Tools

Site Tools


how_to:v3_-_move_message_store_folder

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:v3_-_move_message_store_folder [2012/05/18 10:18] – [Install the PostgreSQL service] paulhow_to:v3_-_move_message_store_folder [2018/12/05 15:25] (current) – [v3/4 - Move the message store to a new folder/drive] paul
Line 12: Line 12:
   - Restart VPOP3   - Restart VPOP3
  
-Note that we can do this for you remotely if you wish, there is a small charge for this (currently £20 + VAT). Contact us on 0800 634 6513 if you wish us to do it for you.+Note that we can do this for you remotely if you wish, there is a small charge for this (currently £50 + VAT). Contact us on 01484 855800 if you wish us to do it for you.
  
 Please note that we do not recommend or support moving the message store to a networked or external (eg USB/Firewire) drive. Please note that we do not recommend or support moving the message store to a networked or external (eg USB/Firewire) drive.
Line 28: Line 28:
   pg_ctl unregister -N "PostgreSQL-VPOP3"   pg_ctl unregister -N "PostgreSQL-VPOP3"
  
 +If that comes back with ''pg_ctl: service "PostgreSQL-VPOP3" not registered'' then try running this instead:
 +  pg_ctl unregister -N "pgsql-8.3"
 =====Move database to the new folder===== =====Move database to the new folder=====
 Move the VPOP3 'pgsql\data' folder and ALL sub-folders to the new location (eg 'd:\vpop3data') Move the VPOP3 'pgsql\data' folder and ALL sub-folders to the new location (eg 'd:\vpop3data')
 +
  
 =====Reassign permissions for PostgreSQL===== =====Reassign permissions for PostgreSQL=====
Line 45: Line 48:
   pg_ctl register -N "PostgreSQL-VPOP3" -D "D:\vpop3data" -U postgres -P vla8Pi4cluwrouDiERiU   pg_ctl register -N "PostgreSQL-VPOP3" -D "D:\vpop3data" -U postgres -P vla8Pi4cluwrouDiERiU
  
 +The 'new data folder' is whatever the new name of the 'pgsql\data' folder is. It is //not// the name of the folder //containing// the new data folder, but the name of the new data folder itself. A simple way to tell this is that the "new data folder" is the path of the folder where the **postgresql.conf** file now resides. So, if your 'postgresql.conf' file is in the 'd:\vpop3data\data' folder, you should specify '' -D "d:\vpop3data\data" '' in the above command.
 +
 +For more information on the pg_ctl command, see the [[http://www.postgresql.org/docs/8.3/static/app-pg-ctl.html|PostgreSQL documentation]]
 =====Restart PostgreSQL===== =====Restart PostgreSQL=====
 Go to Control Panel -> Administrative Tools -> Services, and start the 'PostgreSQL-VPOP3' service Go to Control Panel -> Administrative Tools -> Services, and start the 'PostgreSQL-VPOP3' service
 +
 +=====Large Message Store=====
 +In VPOP3 versions 3 and 4, large messages are not stored in the database, so, if you wish to move those as well, there is a further couple of steps before you restart VPOP3:
 +  - move the VPOP3\_messages folder tree to the new location
 +  - In the Windows registry, find **HKEY_LOCAL_MACHINE\Software\PaulSmith\VPOP3** and set the **MessageStore** value to point to the new location
  
 =====Restart VPOP3===== =====Restart VPOP3=====
 Go to Control Panel -> Administrative Tools -> Services, and start the 'VPOP3 Email Server' service Go to Control Panel -> Administrative Tools -> Services, and start the 'VPOP3 Email Server' service
 +
 +
  
how_to/v3_-_move_message_store_folder.1337332717.txt.gz · Last modified: 2018/11/14 10:44 (external edit)