Upgrading a SQL profiler native package installation on a Linux host v8
To upgrade a SQL Profiler installation that resides on a Linux host:
Delete the existing SQL Profiler query set on each node by invoking the
uninstall-sql-profiler.sql
script. By default, on a Linux host the script resides in theshare/contrib
directory under your EDB Posgtgres Advanced Server or PostgreSQL installation.You can use the following server-specific command:
For PostgreSQL:
Where
x
is the version of PostgreSQL and-d
specifies the name of the maintenance database.For EDB Postgres Advanced Server:
Where
x
is the version of EDB Postgres Advanced Server and-d
specifies the name of the maintenance database.Invoke the new SQL Profiler installer on each node you want to profile.
For PostgreSQL:
Where
x
is the version of the PostgreSQL.For EDB Postgres Advanced Server:
Where
x
is the version of EDB Postgres Advanced Server.The installer detects the existing SQL Profiler installation and upgrades with the latest version of SQL Profiler.
See the following example of upgrading SQL Profiler for PostgreSQL:
Run the
sql-profiler.sql
script file in the maintenance database.For PostgreSQL:
Where
x
is the version of PostgreSQL and-d
specifies the name of the maintenance database.For EDB Postgres Advanced Server:
Where
x
is the version of Advanced Server and-d
specifies the name of the maintenance database.Restart PostgreSQL/EDB Postgres Advanced Server to resume profiling the node from the PEM client.