Upgrade PostgreSQL in an LWA Environment

Description

This article describes how to upgrade PostgreSQL to version 10.17 on Windows 2016 in addition to moving Loftware WebAccess (LWA) to Windows 2016.

LWA customers who have installed LWA on a Windows Server 2008 R2 server can now use these instructions to update that server to Windows Server 2016. That article describes the process for upgrading the operating system of the server on which LWA is running without making any changes or installing new components of the LWA application itself.

Environment

This article describes the creation of an LWA install with the following components

Server A (Windows Server 2016 or 2019):

  • Loftware Print Server (LPS)

Server B (Windows Server 2016):

  • PostgreSQL 10.17
  • LWA v2.4.4 which also includes:
    • Tomcat 6.0.29
    • Java 1.6.0_21
    • Axis 2.2 1.4.1
    • IE 11 should be used as the browser

Upgrade Overview

Perform the following steps to configure your LWA environment.

Step 1: Install LPS on Windows Server 2019

Step 2: Export the data from the original PostgreSQL 8.4 database

Step 3: Install PostgreSQL 8.4 and LWA 2.4.4 on Windows 2008 and Test

Step 4: Upgrade Server B to Windows Server 2016

Step 5: Upgrade PostgreSQL to 10.17 and import the data exported in Step 2

Step 6: Configure and start the LWA environment

Step 1: Install LPS on Server A

  • Install the Loftware Print Server according to the instruction in the installation guide.

Step 2: Export LWA Data

  • Export the data in the existing 8.4 PostgeSQL database. 

In testing at Loftware, we used the Backup Server command in PGAdmin. You can also use the command line. Be sure to back up the server and not just the database.

Step 3: Install PostgreSQL and LWA on Server B

  1. Install PostgreSQL 8.4 and LWA 2.4.4 on a server with Windows 2008 R2 according to the installation instructions.
  2. Test the LWA functionality. 

Step 4: Upgrade Windows Server on Server B

  1. Stop the PostgreSQL and LWA services.
  2. Upgrade Server B to Windows Server 2016. See Upgrade LWA Windows Server for upgrade steps.
  3. Test the LWA functionality.

Step 5: Upgrade PostgreSQL and Import Data on Server B

  1. Stop LWA and PostgreSQL 8.4.
  2. Install PostgreSQL 10.17.

  3. Import the existing PostgreSQL 8.4 data into the upgraded 10.17 server.

You can remove PostgreSQL 8.4 after version 10.17 is installed and the data is imported. 

Step 6: Configure and Start

  1. Update the PostgreSQL JDBC driver.
    • Remove the existing JDBC driver “postgresql-8.3-603.jdbc4.jar” from <Tomcat Base>\webapps\lwaservices\WEB-INF\lib and replace it with the most current JDBC Driver “postgresql-42.2.23.jre6.jar”
    • Remove the existing JDBC driver “postgresql-8.3-603.jdbc4.jar” from <Tomcat Base>\webapps\axis2re\WEB-INF\lib and replace it with the most current JDBC Driver “postgresql-42.2.23.jre6.jar”
  2. Start LWA and Log in.
  3. Verify LWA is working correctly.

Article Number

2021812

Versions

LWA 2.0 and higher.

Environment

LWA, Tomcat, Java