Upgrading from ListManager 8.x

 

 

 

 

     MSDE, MSSQL and Oracle

     

     To upgrade to v9.2 from v8.0 and v8.1

1. Upgrade to v8.95a.

2. Upgrade from v8.95a to v9.2.

 

     To upgrade from v8.5 or higher to v9.2

          Upgrade directly to v9.x.
 

     PostgreSQL

 

     To upgrade to v9.2 from v8.0x through v8.5

1. Upgrade to v8.95a.

2. Upgrade from v8.95a to v9.2.
 

     To upgrade to v9.2 from v8.8

1. Run the query:

 

           ALTER TABLE lyrpipermail DROP CONSTRAINT pk_lyrpipermail;

 

2. Upgrade to v8.95a.

3. Upgrade from v8.95a to v9.2.

 

     To upgrade from any version after v8.9x to v9.2

          Upgrade directly to v9.x.


 

 

Upgrading ListManager--Windows

1. Shut down ListManager and the ListManager web server.

 

2. Double click on the ListManager installer icon.

 

3. Upgrade to the first required version as listed in the instructions above: When running the ListManager installer, select "Upgrade" instead of "New Install", and provide the installer with the path where ListManager is currently installed. The installer will automatically copy the data if necessary and upgrade the database.

     NOTE Upgrading the database may take several hours, depending on the size of your data.

 

4. Allow the installer to start ListManager and the ListManager web server.

 

5. If necessary, close ListManager and the ListManager web server and upgrade one more time to v9.2.

 

Upgrading ListManager: Unix

1. Shut down ListManager and the ListManager web server.

 

2. Untar and unzip the ListManager installer.

 

3. Cd to the directory created by the ListManager installer.

 

4. Run the following command to start the installer:

 

./install_lm.pl

 

5. Upgrade to the first required version as listed in the instructions above: When running the ListManager installer, select "Upgrade" instead of "New Install", and provide the installer with the path where ListManager is currently installed. The installer will automatically copy the data if necessary and upgrade the database.

 

6. Allow the installer to start ListManager and the ListManager web server.

 

7. If necessary, close ListManager and the Listmanager web server and upgrade one more time to v9.2.

 

For details on how to upgrade ListManager on Unix, see How to Upgrade ListManager by Hand.

 

Upgrading and Moving ListManager

Upgrading and Moving--Windows

Upgrading and Moving with MSDE

Upgrading and Moving--Linux/Solaris

Upgrading By Hand--Linux/Solaris

 

Notes

    ListManager 7.5 and above no longer support the Perl-based web interface that was shipped with previous versions of ListManager. This also includes LCP, which may have been used to create custom scripts. If you have been using the old interface extensively or use custom scripting to run certain portions of ListManager prior to ListManager 7.5 (including list member signup forms), please contact support prior to upgrading.

    New tables created by ListManager in MSSQL will be owned by DBO. In versions before 8.1, the ListManager tables were owned by the user.