User Tools

Site Tools


how_to:v5_-_move_the_message_store_to_a_new_folder_drive

v5 - Move the message store to a new folder/drive

Here is an 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.

  1. Stop VPOP3
  2. Stop PostgreSQL
  3. Remove the PostgreSQL service
  4. Move database to the new folder
  5. Reassign permissions for PostgreSQL
  6. Reinstall the PostgreSQL service
  7. Restart PostgreSQL
  8. Restart VPOP3

See the 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 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

how_to/v5_-_move_the_message_store_to_a_new_folder_drive.txt · Last modified: 2019/11/12 16:10 by paul