Upgrading a PEM installation on a Linux host v10

To upgrade PEM component software on Linux hosts, install a newer version of the PEM component packages in the following order:

  1. Invoke the PEM agent package installer on each monitored node except the PEM server host.
  2. Invoke the PEM server package installer. It upgrades both the PEM server and the PEM agent that resides on the PEM server host. If the web application and backend database are running on separate hosts, update the database host first.

During an installation, the component installation detects an existing installation and performs an upgrade. After upgrading the PEM agent and server, you can upgrade SQL Profiler if required. That step is platform specific.

!!! Upgrading to PEM 10 from PEM 9 To upgrade to PEM 10 from PEM 9 you can follow the steps below. Note that, while new installations of PEM 10 use the NGINX web server by default, installations upgraded from PEM 9 will continue to use Apache HTTPD. After upgrading to PEM 10, you can switch to NGINX at any time by running the provided script /usr/edb/pem/bin/switch-web-server.sh. This will install and configure NGINX. You can run the same script again to switch back to Apache HTTPD. !!!

Upgrading a PEM server installation

If you want to upgrade a PEM server that's installed on a machine in an isolated network, you need to create a PEM repository on that machine before you upgrade the PEM server. For more information, see Creating an EDB repository on an isolated network.

To upgrade a PEM server installation:

sudo <package-manager> upgrade edb-pem

Where <package-manager> is the package manager used with your operating system:

Package managerOperating system
dnfRHEL 8/9 and derivatives
zypperSLES
apt-getDebian and Ubuntu

After upgrading the PEM server, you must configure the PEM server. For detailed information, see Configuring the PEM server.

Note

If you upgrade the PEM backend database server and the PEM server, update the PG_INSTALL_PATH and DB_UNIT_FILE parameters pointing to the new version in the /usr/edb/pem/share/.install-config file before you run the configure script.

Configuring the PEM server

After upgrading the PEM server, you can use the following command to configure the PEM server:

/usr/edb/pem/bin/configure-pem-server.sh

The configure script uses the values from the old PEM server configuration file while running the script. For details, see Configuring the PEM server on Linux platforms.

Note
  • The configure script requires a superuser password only after the upgrade process.

  • If your configure script gets stuck, then stop the PEM agent with alert_threads>0. To get the details of such agents, execute the query:

    SELECT agent_id FROM pem.agent_config WHERE param='alert_threads' AND value > 0;

    Stop the running agents and rerun the configure script.

    If the problem persists, then run the query to terminate the stuck alert processes:

    SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE query='SELECT pem.process_one_alert()';

    Then rerun the configure script.

Upgrading a PEM agent installation

To upgrade a PEM agent:

sudo <package-manager> upgrade edb-pem-agent

Where <package-manager> is the package manager used with your operating system:

Package managerOperating system
dnfRHEL 8/9 and derivatives
zypperSLES
apt-getDebian and Ubuntu