Upgrading a PEM installation on a Linux host v9

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.

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.

Note

If you already configured or are planning to configure any shell/batch script run by a Linux agent that's upgraded from any earlier version to version 7.11 or later, you must specify the user for the batch_script_user parameter in the agent.cfg file. We strongly recommended that you use a non-root user to run the scripts. Using the root user can result in compromising the data security and operating system security. However, if you want to restore the pemagent to its original settings using a root user to run the scripts, then you must set the batch_script_user parameter to root.

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