up vote 41 down vote favorite
6
share [fb]

I refer this to enable the debugger in the PostgreSQL server in order to debugging the plpgsql function by stepping through the codes using the pgadmin.

I have already set shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' in the postgresql.conf, run pldbgapi.sql , and restarted the server.

These steps should have been run successfully and plugin_debugger.dll should be loaded successfully as can be verified by using the command show shared_preload_libraries, and I can see the debugging option in the context menu with a right click on a function in pgAdmin.

enter image description here

When choosing "Debugging" --> Debug, a window pops up to allow me to enter the values for the input parameters. But after that, when I press OK, it does not respond at all.

enter image description here

Any ideas or did I miss something in the setup of the debugger on the server??

I am using PostgreSQL 8.3 and pgAdmin 1.14

link|improve this question
60% accept rate
6  
+1 good question. I don't know why it fails, though. If nothing turns up, you can always send your question to the pgAdmin support list: [email protected] (include a link to your question here). See the list archive here. – Erwin Brandstetter Oct 23 at 11:02
Thanks Erwin for the link , I have already sent the questions to the pgAdmin support – Ken Chan Oct 24 at 4:38
4  
And you are running as super user? According to the site you refer to one needs to be super user in order for it to work. – John P Nov 12 at 9:11
Yes , I am the super user account . The same problem exists even I use the postgres account that is created by default – Ken Chan Nov 12 at 9:40
show 8 more comments
feedback

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.