debugging - PostgreSQL 9.2 EnterpriseDB for Win7 x-64 是否没有调试器插件

Question

我按照安装说明 C:\Program Files\PostgreSQL\9.2\doc\installation-notes.html

编辑 postgresql.conf 文件 shared_preload_libraries = '$libdir/plugin_debugger.dll'

停止并重新启动 pgAdmin 中的 PostgreSQL 服务

进入数据库并运行 CREATE EXTENSION pldbgapi;成功返回。

但是当我在 pgAdmin 的 TreeView 中右键单击一个函数时，没有调试选项并且调试选项在工具菜单上呈灰色。

pl/pgsql Debugger

The package includes EnterpriseDB's pl/pgsql debugger plugin which may be used by the debugger UI in pgAdmin to help with development of your database functions. The debugger plugin is disabled by default for performance reasons. To enable it, follow the following steps: 1.Edit the postgresql.conf file in the data directory and modify the shared_preload_libraries config option to look like the following, if running 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.Restart the PostgreSQL server.

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

关联:
https://www.pgadmin.org/docs/dev/debugger.html

Answer 1

必须进入“工具”菜单上的“服务器配置”并启用 shared_preload_libraries项目旁边的复选框。单独编辑配置文件和退回数据库服务器不会在数据库中启用调试器。