On Mon, 2012-01-30 at 11:40 +0100, ulrike.sa...@t-online.de wrote: > Hi, > > after installing postgSQL 9.1.2 including pgAdmin III 1.14 on Windows > XP i tried to activate the debugger. > > I followed the instructions > > 1. Edit the postgresql.conf file in the data directory and modify the > shared_preload_libraries config option to look like the following, > > Windows: > > shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' >
Can you try without the '.dll' in the name? I never add .dll and .so extensions for shared libraries in shared_preload_libraries GUC. > 2. Restart the PostgreSQL server. > > 3. Run <Installation directory>/share/contrib/pldbgapi.sql on Windows > in the database you wish to debug using psql or the pgAdmin query > tool. > > Every Step worked and is verified, but the debugger in pgAdmin > remains disabled. > > Restarting the server, it says that the plugin_debugger.dll is > loaded. The generated functions (pldbapi.sql) are displayed and > available in the database, but however pgAdmin seems not to recognize > the debugger plugin. > > What can I do? I need the debugger to debug functions and for a > postgreSQL presentation that takes place at Friday. > Sorry for not responding sooner. I installed the debugger on a 9.1.2 PostgreSQL server, and pgAdmin 1.14.1 sees it, and allows me to launch the debugger. So, two questions: 1. are you sure you're connected to the database with the pldbg_get_target_info and edb_oid_debug functions? 2. are you sure you selected a plgpsql function? (I ask this because I just went through a lot of troubles debugging pgAdmin to finally notice that I had selected a sql function... I know, pretty silly of me :) ) -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
