[pgadmin-support] Debugging grayed out even pldebugger is installed in postgres
Hello, I don't know why, but I am unable to use debugging feature in pgAdminIII. Debugging selection in menu is still greyed out. My environment is: Linux Fedora 9, Postgres 8.4.0, PLpgSQL Debugger (latest CVS - version 1.11) pgAdminIII 1.10.0 - Windows version Debugger is installed in PostgreSQL, library plugin_debugger.so is loaded and pldbgapi.sql script was used to create debug functions in desired database. If I open database in PgAdminIII and look into Funcions, debugging functions like ladbg_get_target_info or pldbg_set_brakepoint are present and it looks that they are working, because I am able to call them in SQL. But still debugging is not available from menu. No debugging in context menu and debugging in main menu is still greyed out. I thought that there could be something wrong in so recent versions, so I tried to compile PostgreSQL 8.3.7 from source with PlpgSQL 0.93, but still no luck. Still no debugging in pgAdminIII. Thanks, Petr -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Debugging grayed out even pldebugger is installed in postgres
2009/8/3 Dave Page : > Please keep the thread on the mailing list or I will have to stop > replying. I do not provide private support. I am really sorry, I didn't want to send private messages. > > On Mon, Aug 3, 2009 at 12:49 PM, Petr Vodicka wrote: > >>> What does the SQL query: >>> >>> show shared_preload_libraries; >>> >>> return? >>> >> Weird, only one empty row. So I tried to load library manually with >> LOAD '$libdir/plugins/plugin_debugger.so';. After that LOAD returned, >> so It looks like everything is ok, but still only one empty row returned >> if I enter show shared_preload_libraries; command. >> >> I have local_preload_libraries = 'libdir/plugins/plugin_debugger.so' >> parameter >> in my postgresql.conf, so I think, that it shoul be loaded after postgresql >> start. But somethink is probably wrong... >> > > That should be: > > shared_preload_libraries = '$libdir/plugins/plugin_debugger.so' > That was the problem. Now "show shared_preload_libraries;" command returns: shared_preload_libraries $libdir/plugins/plugin_debugger.so (1 row) and debugging in pgAdminIII is working. Thank you for your help. I would not be able to make it working without you. Have a nice day, Petr -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
