The steps required to upgrade SQL Profiler are platform-specific; please see the section for your platform for detailed information.
1. Delete the existing SQL Profiler query set on each node by invoking the uninstall-sql-profiler.sql script.By default, if you are using Advanced Server on a Linux host that was installed with a graphical installer, the script resides in:/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.On Windows, you can use the Services dialog to control the service. To open the Services dialog, navigate through the Control Panel to the System and Security menu. Select Administrative Tools, and then double-click the Services icon. When the Services dialog opens, highlight the service name in the list, and use the option provided on the dialog to Stop the service.
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.