Uninstalling SQL Profiler

You must uninstall SQL Profiler on each Postgres database server where you want to remove it.

To uninstall SQL Profiler:

  1. Drop the sql_profiler extension:

    # Connect to your database using psql
    psql -d postgres -U enterprisedb
    # Drop the extension
    DROP EXTENSION sql_profiler;
  2. Edit the postgresql.conf file on the server you want to remove the extension, deleting the shared_preload_libraries parameter line.

    In Linux, remove:

    shared_preload_libraries = `$libdir/sql_profiler`

    In Windows, remove:

    shared_preload_libraries = `$libdir/sql_profiler.dll`
  3. Restart the Postgres database server to apply the changes.


Could this page be better? Report a problem or suggest an addition!