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
Last revisionBoth sides next 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/11/14 10:45] – external edit 127.0.0.1
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.txt · Last modified: 2018/12/05 15:25 by paul