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.
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.
Go to Control Panel → Administrative Tools → Services, and stop the 'VPOP3 Email Server' service
Go to Control Panel → Administrative Tools → Services, and stop the 'VPOP3DB' service
At a command prompt, navigate to your VPOP3 directory, then the pgsql\bin directory under that
pg_ctl unregister -N "vpop3db"
Move the VPOP3 'pgsql/data' folder and ALL sub-folders to the new location (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).
At a command prompt, navigate to your new VPOP3 directory, then the pgsql\bin directory under that
pg_ctl register -N "VPOP3DB" -D "<new data folder>" -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 PostgreSQL documentation
Go to Control Panel → Administrative Tools → Services, and start the 'VPOP3DB' service
Go to Control Panel → Administrative Tools → Services, and start the 'VPOP3 Email Server' service