User Tools

Site Tools


how_to:v3_-_move_message_store
no way to compare when less than two revisions

Differences

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 'pgInstaller' version of PostgreSQL from the [[http://www.postgresql.org/download/windows|PostgreSQL website]]. VPOP3 has been developed using the 8.3 versions of PostgreSQL (the 8.4 versions may work, but have not been tested). At the time of writing, the latest 8.3 version is 8.3.8 so the download can be found at http://www.postgresql.org/ftp/binary/v8.3.8/win32/ . The actual download is [[http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.3.8/win32/postgresql-8.3.8-1.zip|postgresql-8.3.8-1.zip]].
 +
 +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 'pgsqlpass' as the default password here, so you may wish to use the same.
 +
 +====Set Network Permissions for PostgreSQL====
 +In the PostgreSQL installation directory find the **data** subdirectory. Open the file 'pg_hba.conf' in Notepad.
 +
 +Under the line saying:
 +
 +**host  all  all  127.0.0.1/32    md5**
 +
 +add another line like:
 +
 +**host  all  all  192.168.0.1/32  md5**
 +
 +Change the network address as appropriate for your VPOP3 computer. Save the file.
 +
 +Open the 'postgresql.conf' file in Notepad
 +
 +Find the line saying:
 +
 +**#listen_addresses = 'localhost'**
 +
 +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, if your PostgreSQL installation is non-standard, then you may need to change this command appropriately)
 +
 +This will create a file 'database.dmp' containing a backup of the database in the VPOP3 directory.
 +
 +Copy this 'database.dmp' file to the new PC.
 +
 +=====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 'PostGreSQLHostAddr' to the IP address of the new PC, and clear the value of 'PostGreSQLHostName'.
 +
 +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://www.pscs.co.uk/helpdesk/index.php#SUP|chargeable support facility]].
how_to/v3_-_move_message_store.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1