Is the debugger plug-in unavailable for PostgreSQL 9.2 EnterpriseDB for Win7 x-64

Question

I followed the installations C: \ Program Files \ PostgreSQL \ 9.2 \ doc \ installation-notes.html

• Edited postgresql.conf shared_preload_libraries = '$libdir/plugin_debugger.dll'
• PostgreSQL service stopped and restarted in pgAdmin
• I went into the database and launched CREATE EXTENSION pldbgapi; who returned with success.

But when I right-click on a function in TreeView pgAdmin, there is no debugging option, and the debugging option is grayed out in the "Tools" menu.

pl / pgsql debugger

The package includes the EnterpriseDB pl / pgsql debugger plugin, which can be used by the debugger interface in pgAdmin to help develop your database function. The debugger plugin is disabled by default for performance. To enable it, follow these steps: 1. Change the postgresql.conf file in the data directory and change the shared_preload_libraries configuration parameter to look like this: if it works on Linux or Mac: shared_preload_libraries = '$ libdir / plugin_debugger.so' or if you are on Windows:
shared_preload_libraries = '$ libdir / plugin_debugger.dll'

2. Reboot the PostgreSQL server.

3.Run CREATE EXTENSION pldbgapi; in the database you want to debug with psql or the pgAdmin query tool.

link: https://www.pgadmin.org/docs/dev/debugger.html

Answer 1

You need to enter the server configuration in the "Tools" menu and enable the shared_preload_libraries element by checking the box next to it. Editing the configuration file and switching to the database server does not allow the debugger in the database.