User Tools

Site Tools


how_to:v5_-_move_the_message_store_to_a_new_folder_drive

This is an old revision of the document!


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

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

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.

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 postgres 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

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.1324294663.txt.gz · Last modified: 2018/11/14 10:44 (external edit)