This shows you the differences between two versions of the page.
Previous revision | |||
— | how_to:v3_-_move_message_store [2018/11/14 10:45] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ======How to move the VPOP3 Message Store to a new PC====== | ||
+ | Use this option if you want to have VPOP3 running on one PC, but have the message store database on another PC. | ||
+ | =====Manually Install PostgreSQL on the new PC===== | ||
+ | Download the ' | ||
+ | |||
+ | Download this installer and run it on the new PC. The settings here do not matter, so usually you can just use the default settings. Just make sure you remember the PostgreSQL superuser password - the VPOP3 installer uses ' | ||
+ | |||
+ | ====Set Network Permissions for PostgreSQL==== | ||
+ | In the PostgreSQL installation directory find the **data** subdirectory. Open the file ' | ||
+ | |||
+ | Under the line saying: | ||
+ | |||
+ | **host | ||
+ | |||
+ | add another line like: | ||
+ | |||
+ | **host | ||
+ | |||
+ | Change the network address as appropriate for your VPOP3 computer. Save the file. | ||
+ | |||
+ | Open the ' | ||
+ | |||
+ | Find the line saying: | ||
+ | |||
+ | **# | ||
+ | |||
+ | Add a line under that saying: | ||
+ | |||
+ | **listen_addresses = ' | ||
+ | |||
+ | Restart the PostgreSQL service in Windows. | ||
+ | |||
+ | |||
+ | =====Stop VPOP3===== | ||
+ | [[Stop VPOP3]] on the original PC | ||
+ | |||
+ | =====Backup the database===== | ||
+ | To backup the database, go to a command prompt on the VPOP3 computer, and go to the VPOP3 directory. Then run | ||
+ | **pgsql\bin\pg_dump -F c -U vpop3 -f database.dmp** | ||
+ | |||
+ | At the password prompt, type **vpop3pass** | ||
+ | (This assumes a standard installation, | ||
+ | |||
+ | This will create a file ' | ||
+ | |||
+ | Copy this ' | ||
+ | |||
+ | =====Restore the Database Backup===== | ||
+ | On the new PC, open up a command prompt and go to the VPOP3 directory. Then run | ||
+ | |||
+ | **pgsql\bin\pg_restore -U postgres -d vpop3 database.dmp** | ||
+ | |||
+ | At the command prompt, enter **pgsqlpass** (or the password you defined for the PostgreSQL superuser) | ||
+ | |||
+ | This will import the data to the database system on the new PC | ||
+ | |||
+ | |||
+ | |||
+ | =====Change the database settings in VPOP3===== | ||
+ | On the VPOP3 computer go to **Start -> Run** and run **RegEdit**. | ||
+ | |||
+ | In the left pane find HKEY_LOCAL_MACHINE\Software\PaulSmith\VPOP3\Database | ||
+ | In the right pane, set ' | ||
+ | |||
+ | Restart VPOP3 and check it works. | ||
+ | |||
+ | =====We can do it for you===== | ||
+ | If you have any problems with this, or find the prospect daunting, we can do this remotely for you under our [[http:// |