PEM documentation and links to PEM and SQL Profiler installers are available from the EnterpriseDB website at:To upgrade your version of PEM, simply invoke the PEM component installers. Each installer will notify you if it detects a previous installation, and will upgrade to the more recent version of PEM.
1. Invoke the PEM agent installer on each monitored node except the PEM server node.
2. Invoke the PEM server installer; this installer will upgrade both the PEM server and the PEM agent that resides on the PEM server node.
1. Delete the existing SQL Profiler query set on each node by invoking the uninstall-sql-profiler.sql script./opt/PostgresPlus/9.x/share/contrib/opt/PostgreSQL/9.x/share/postgresql/contribWhere x specifies the installed Postgres version.If you are using SQL Profiler on a Windows host, Windows will lock any files that have been executed or loaded into memory. To release any locked files, you must stop the Postgres server before performing an upgrade.For information about controlling the server, please see , Controlling a Service on Windows.
1. Delete the existing SQL Profiler query set on each node by invoking the uninstall-sql-profiler.sql script.C:\Program Files\PostgresPlus\9.x\share\contribC:\Program Files\PostgreSQL\9.x\share\contribWhere x specifies the installed Postgres version.An error has occurred:
ERROR: function return row and query-specified return row do not match
DETAIL: Returned row contains 11 attributes, but query expects 10.To correct this error, you must replace the existing query set with a new query set. First, uninstall SQL Profiler by invoking the uninstall-sql-profiler.sql script, and then reinstall SQL Profiler by invoking the sql-profiler.sql script.Use the uninstallers provided in the PEM installation directory to remove PEM components from an Advanced Server or PostgreSQL installation on Linux or Solaris. By default, the PEM uninstallers are located:
To remove a component, assume superuser privileges, open a terminal window, and navigate into the directory in which the uninstaller resides; invoke the installer as follows:./uninstall-component_nameWhere component_name is the name of the component that you wish to remove.If the PEM installation resides on a Windows host, you can use the Windows Uninstall a Program applet to remove PEM components. To open the Uninstall a Program application, navigate through the Programs submenu on the Windows Control Panel, selecting Programs and Features. When the Uninstall a Program window opens, highlight the name of the PEM component that you wish to remove, and click the Uninstall/Change button. A Windows popup will open, prompting you to confirm that you wish to remove the component; click Yes to remove the component.