======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.

  - Stop VPOP3
  - Stop PostgreSQL
  - Remove the PostgreSQL service
  - Move database to the new folder
  - Reassign permissions for PostgreSQL
  - Reinstall the PostgreSQL service
  - Restart PostgreSQL
  - Restart VPOP3

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=====
Go to Control Panel -> Administrative Tools -> Services, and stop the 'VPOP3 Email Server' service

=====Stop PostgreSQL=====
Go to Control Panel -> Administrative Tools -> Services, and stop the 'VPOP3DB' service

=====Remove the PostgreSQL service=====
At a command prompt, navigate to your VPOP3 directory, then the **pgsql\bin** directory under that

Run
  pg_ctl unregister -N "vpop3db"

=====Move database to the new folder=====
Move the VPOP3 'pgsql/data' folder and ALL sub-folders to the new location (eg 'd:\vpop3data')

=====Reassign permissions for PostgreSQL=====
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).

=====Install the PostgreSQL service=====
At a command prompt, navigate to your new VPOP3 directory, then the **pgsql\bin** directory under that

Run
  pg_ctl register -N "VPOP3DB" -D "<new data folder>" -U vpop3postgres -P Nc6ACboDt2jVL6

e.g. Run
  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=====
Go to Control Panel -> Administrative Tools -> Services, and start the 'VPOP3DB' service

=====Restart VPOP3=====
Go to Control Panel -> Administrative Tools -> Services, and start the 'VPOP3 Email Server' service