PSCS Wiki

User Tools

Site Tools

Trace:
how_to:v5_-_move_the_message_store_to_a_new_folder_drive

Differences

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

Link to this comparison view

Next revision		Previous revision
how_to:v5_-_move_the_message_store_to_a_new_folder_drive [2011/12/19 11:37] – created paulhow_to:v5_-_move_the_message_store_to_a_new_folder_drive [2019/11/12 16:10] (current) – [v5 - Move the message store to a new folder/drive] paul
Line 1: Line 1:
 ======v5 - Move the message store to a new folder/drive====== ======v5 - Move the message store to a new folder/drive======
 +
 +Here is an [[Move the message store - alternative method|alternative method]], which may be simpler, but only moves the data, not the whole database store (which is a subtle difference)
  
 This guide assumes you want to just move the VPOP3 message store/database to a new folder on the same PC, and leave the VPOP3 installation directory where it is. This guide assumes you want to just move the VPOP3 message store/database to a new folder on the same PC, and leave the VPOP3 installation directory where it is.
Line 12: Line 14:
   - 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.+See the [[video:move_the_vpop3_message_store_to_a_new_folder_drive_-_v5|video tutorial]]
  
 +Note that we can do this for you remotely if you wish, there is a small charge for this (currently £40 + VAT). Contact us on 01484 855800 if you wish us to do it for you.
 =====Stop VPOP3===== =====Stop VPOP3=====
 Go to Control Panel -> Administrative Tools -> Services, and stop the 'VPOP3 Email Server' service Go to Control Panel -> Administrative Tools -> Services, and stop the 'VPOP3 Email Server' service
Line 30: Line 33:
  
 =====Reassign permissions for PostgreSQL===== =====Reassign permissions for PostgreSQL=====
-You need to assign permission for the **postgres** user to the new folder (eg 'd:\vpop3data')+You need to assign permission for the **vpop3postgres** user to the new folder (eg 'd:\vpop3data')
  
 To do this, go to the parent folder in Windows Explorer (eg if the database has been moved to 'd:\vpop3data', go to the 'd:\' folder) . Right-click the new data folder and choose Properties, then Security. Add permission for the **vpop3postgres** user to have full permission to access this folder. (On an Active Directory Controller, the **vpop3postgres** user is a domain user, on all other types of PC, the **vpop3postgres** user is a local user). To do this, go to the parent folder in Windows Explorer (eg if the database has been moved to 'd:\vpop3data', go to the 'd:\' folder) . Right-click the new data folder and choose Properties, then Security. Add permission for the **vpop3postgres** user to have full permission to access this folder. (On an Active Directory Controller, the **vpop3postgres** user is a domain user, on all other types of PC, the **vpop3postgres** user is a local user).
Line 43: Line 46:
   pg_ctl register -N "VPOP3DB" -D "D:\vpop3data" -U vpop3postgres -P Nc6ACboDt2jVL6   pg_ctl register -N "VPOP3DB" -D "D:\vpop3data" -U vpop3postgres -P Nc6ACboDt2jVL6
  
 +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/9.1/static/app-pg-ctl.html|PostgreSQL documentation]]
 =====Restart PostgreSQL===== =====Restart PostgreSQL=====
 Go to Control Panel -> Administrative Tools -> Services, and start the 'VPOP3DB' service Go to Control Panel -> Administrative Tools -> Services, and start the 'VPOP3DB' service
how_to/v5_-_move_the_message_store_to_a_new_folder_drive.1324294663.txt.gz · Last modified: 2018/11/14 10:44 (external edit)

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki