This shows you the differences between two versions of the page.
— | how_to:upgrade_vpop3_to_version_8 [2020/09/03 15:07] (current) – created paul | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ======Upgrading VPOP3 to version 8.x from v7 or earlier====== | ||
+ | VPOP3 v8.x uses PostgreSQL 10 as its database engine, which is the latest supported 32 bit version of PostgreSQL. Later versions of PostgreSQL are 64-bit only, which means we cannot use them while continuing to support 32 bit versions of Windows. | ||
+ | |||
+ | Because this is a later version of PostgreSQL than earlier versions of VPOP3 (v3 & 4 use 8.3, v5 & 6 use 9.1, v7 uses 9.5) the VPOP3 installer has to perform a database upgrade. | ||
+ | |||
+ | **We recommend having a recent database backup before running the installer to upgrade to VPOP3 7 or later. You could use the most recent daily database backup that VPOP3 usually makes automatically, | ||
+ | |||
+ | ====Upgrading from v5 or later==== | ||
+ | |||
+ | When upgrading from VPOP3 v5 or later, this should be a relatively quick process, usually taking no longer than a few minutes. The installer uses the ' | ||
+ | |||
+ | At the end of the pg_upgrade process, the command prompt window will ask you | ||
+ | |||
+ | Does everything above look OK (Y/N)? | ||
+ | | ||
+ | Have a quick look back through the pg_upgrade output, and if there are no reports of ERRORS (or FATAL or PANIC errors) then press ' | ||
+ | |||
+ | If you see any errors, press ' | ||
+ | |||
+ | ====Upgrading from v3 or v4==== | ||
+ | When upgrading from VPOP3 v3 or v4, then the pg_upgrade method cannot be used, so the installer has to perform a full database backup & restore, which can take some time, depending on the size of the database. | ||
+ | |||
+ | When upgrading from VPOP3 v3 or v4, you **must** initially install the 32-bit version of VPOP3 v8 to migrate the data correctly. Once the data has migrated into the database, you can then over-install the 64-bit version if desired. | ||
+ | |||
+ | ====Upgrading from v2 or earlier==== | ||
+ | Whilst VPOP3 v2 did support the use of PostgreSQL to speed up busy systems, this was rarely used. | ||
+ | |||
+ | In all other cases, the upgrade from v2 to v8 should be straightforward because VPOP3 will automatically migrate the data from the old registry & file-based store to the database store. However, you **must** initially install the 32-bit version of VPOP3 v8 to migrate the data correctly. Once the data has migrated into the database, you can then over-install the 64-bit version if desired. |