This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
how_to:v3_-_move_message_store_folder [2012/01/30 13:33] – created paul | how_to:v3_-_move_message_store_folder [2012/06/21 09:26] – [Install the PostgreSQL service] paul | ||
---|---|---|---|
Line 13: | Line 13: | ||
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 £20 + VAT). Contact us on 0800 634 6513 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/ | ||
=====Stop VPOP3===== | =====Stop VPOP3===== | ||
Line 26: | Line 28: | ||
pg_ctl unregister -N " | pg_ctl unregister -N " | ||
+ | If that comes back with '' | ||
+ | pg_ctl unregister -N " | ||
=====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 ' | + | Move the VPOP3 'pgsql\data' folder and ALL sub-folders to the new location (eg ' |
+ | Do not move the ' | ||
+ | |||
+ | So, if you are using our example of ' | ||
=====Reassign permissions for PostgreSQL===== | =====Reassign permissions for PostgreSQL===== | ||
You need to assign permission for the **postgres** user to the new folder (eg ' | You need to assign permission for the **postgres** user to the new folder (eg ' | ||
Line 35: | Line 42: | ||
=====Install the PostgreSQL service===== | =====Install the PostgreSQL service===== | ||
- | At a command prompt, navigate to your new VPOP3 directory, then the **pgsql\bin** directory under that | + | At a command prompt, navigate to the VPOP3 directory, then the **pgsql\bin** directory under that |
Run | Run | ||
Line 43: | Line 50: | ||
pg_ctl register -N " | pg_ctl register -N " | ||
+ | The 'new data folder' | ||
+ | |||
+ | For more information on the pg_ctl command, see the [[http:// | ||
=====Restart PostgreSQL===== | =====Restart PostgreSQL===== | ||
Go to Control Panel -> Administrative Tools -> Services, and start the ' | Go to Control Panel -> Administrative Tools -> Services, and start the ' | ||
+ | |||
+ | =====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' | Go to Control Panel -> Administrative Tools -> Services, and start the 'VPOP3 Email Server' | ||
+ | |||
+ | |||