PEM Upgrade and Migration

This guide provides detailed information about upgrading the Postgres Enterprise Manager (PEM) Components:

• Upgrading a PEM Installation - This section provides information about upgrading your PEM server, PEM Agent and SQL Profiler from one major version to another (i.e. from 6.0 to 7.14).

• Upgrading the Backend Database - This section provides detailed information about upgrading the backing database, while maintaining the same version of the PEM Server.

• Moving a PEM Server –This section provides detailed information about moving the PEM server from one host to another host.

• Troubleshooting –This section provides detailed information about troubleshooting the errors that you may encounter during PEM upgrade.

This document uses the term Postgres to mean either the PostgreSQL or the Advanced Server database.

• Upgrading a PEM Installation
  • Upgrading a PEM Installation on Windows Host
    • Upgrading a PEM Agent on a Windows Host
    • Upgrading the PEM Server on a Windows Host
    • Upgrading SQL Profiler on a Windows Host
  • Upgrading a PEM Native Package Installation on a Linux Host
    • Prerequisites to Upgrade a PEM Installation on Linux Host
    • Upgrading a PEM Agent Native Package Installation
      • Upgrading the PEM Agent on a CentOS or RHEL Host
      • Upgrading a PEM Agent on a Debian or Ubuntu Host
      • Upgrading a PEM Agent on a SLES Host
    • Upgrading a PEM Server Native Package Installation
      • Upgrading a PEM Server on a CentOS or RHEL Host
      • Upgrading the PEM Server on a Debian or Ubuntu Host
      • Upgrading the PEM Server on a SLES Host
    • Upgrading a SQL Profiler Native Package Installation
  • Creating a PEM Repository on an Isolated Network
  • Upgrading a Graphical PEM Installation on a Linux Host
    • Prerequisites to Upgrade a PEM Installation on a Linux Host
    • Upgrading a PEM Agent (Graphical Installation) on a CentOS or RHEL Host
    • Upgrading a PEM Server that was Installed with a Graphical Installer
      • Upgrading a PEM Server that was Installed with a Graphical Installer on a CentOS or RHEL Host
    • Upgrading a SQL Profiler Installation with a Graphical Installer
  • Configuring a PEM Server on a Linux Host
• Upgrading the PEM Backend Postgres Database
• Moving the Postgres Enterprise Manager Server
• Troubleshooting
  • Reconfiguring the PEM Server
• Conclusion