Upgrade and migration

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

• UpgradingaPEMInstallation - Provides information about upgrading your PEM Server, PEM Agent and SQL Profiler from one major version to another.

• UpgradingthePEMBackendDatabase - Provides detailed information about upgrading the backend database, while maintaining the same version of the PEM Server.

• UpgradingSQLProfiler - Provides detailed information about upgrading the SQL Profiler.

• MovingthePEMServer – Provides detailed information about moving the PEM Server from one host to another host.

• Troubleshooting – 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 or EDB Postgres Extended (formerly known as 2ndQPostgres).

Note

If you are upgrading PEM 7.x to the latest version and the PEM backend database is PostgreSQL or EDB Postgres Advanced Server version 10 or earlier then follow these steps: 1. Upgrade the PEM backend database 2. Upgrade the PEM Installation

If the PEM backend database is PostgreSQL or EDB Postgres Advanced Sever version 11 or later then upgrading the PEM backend database is optional.

• Upgrading a PEM installation
  • 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 a PEM server native package installation
    • Configuring the PEM server
  • Upgrading a PEM Installation on a Windows host
    • Upgrading a PEM agent on a Windows host
    • Upgrading the PEM server on a Windows host
• Upgrading the PEM backend Postgres database
• Upgrading SQL Profiler
  • Upgrading a SQL profiler native package installation on a Linux host
  • Upgrading a SQL Profiler installation on a Windows host
• Moving the PEM server