While upgrading from PureMessage 5.6.1 to 6.x, you have the option of using the PureMessage migration script (pmx-v6-migrate) to import data into the new version of PureMessage.
If your database in version 5.6.1 is using an unexpected locale (anything other than "C"), an error message will be displayed when you attempt the "Database and Quarantine" stage of the migration. A message similar to the following is displayed:
Unable to migrate database data due to locale mismatch (current: en_US.UTF-8, required: C).
You must perform the manual steps described below to transfer the PureMessage database, and then the quarantine, from the old installation to the new installation.
Note: These instructions assume the default installation directories of /opt/pmx (version 5.6.1) and /opt/pmx6 (version 6.x). If your locations differ, adjust the relevant paths shown below as necessary.
As the PureMessage 5 user, stop all PureMessage processes, along with the mail transfer agent that PureMessage uses.
pmx stop ; pmx-service stop smtp
As the PureMessage 6 user, stop all PureMessage processes, and the mail transfer agent that PureMessage uses.
As the PureMesssage 5 user, start the database:
As the PureMessage 5 user, run the following command to dump and temporarily store the contents of the database.
/opt/pmx/postgres/bin/pg_dump -E SQL_ASCII -x -c -O pmx_quarantine > <PathToDumpDirectory>
As the PureMessage 5 user, stop the database:
As the PureMessage 6 user, copy the dumped database file to a temporary location within the version 6.x installation directory.
As the PureMessage 6 user, start the database:
As the PureMessage 6 user, run the following command to import the dumped data into the PureMessage 6 database:
/opt/pmx6/postgres/bin/psql pmx_quarantine < <PathToCopiedDumpFile>
As the PureMessage 6 user, finalize the importation of the data by running the following:
Once you have successfully imported the contents of the PureMessage 5 database, you are ready to do the same with the PureMessage quarantine.
As the PureMessage 6 user, create a backup of the quarantine directory (/opt/pmx6/var/qdir).
As the root user, copy the 5.6.1 configuration file that specifies the location of the PureMessage installation (/opt/pmx/etc/location.conf) to the PureMessage 6 installation directory (/opt/pmx6/etc/location.conf).
As the PureMessage 6 user, run these two additional commands to finalize the quarantine migration:
As the PureMessage 6 user, start PureMessage and the mail transfer agent that PureMessage uses:
pmx start ; pmx-service start smtp
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. If you need technical support please post a question to our community. Alternatively for licensed products open a support ticket.