Dave Page Re: Installing debugger? This was extremely hard to make work, and very kludgy. Might be worth just saying in the docs that the debugger currently isn't supported except on EDB and One-Click installs. Having gone to some trouble to get it installed, however, I find that the "debugging" option on the pgadmin menu is still greyed out and inaccessible.
What is pgAdmin looking for? Ashesh Vashi. Database Server Restart required. The required functions for pldebugger in postgres database. You can install them using the sql file provided under the debugger module.
In reply to this post by Josh berkus. Feel free to provide a patch for the Makefile if you have that itch. I'm not going to say it isn't supported, as it is and works fine, it's just awkward to build. Superuser privs or ownership of the function. I figured the build issues around edb-debugger belong on that project's list. Warning: This documentation is for a pre-release version of pgAdmin 4.
You must have superuser privileges to use the debugger. Before using the debugger, you must modify the postgresql. The debugger may be used for either in-context debugging or direct debugging of a target function or procedure. When you use the debugger for in-context debugging, you set a breakpoint at the first line of a program; when a session invokes the target, control is transferred to the debugger.
When using direct debugging, the debugger prompts you for any parameters required by the target, and then allows you to step through the code. To set a breakpoint at the first line of a program, right-click the name of the object you would like to debug, and select Set breakpoint from the Debugging sub-menu. The debugger window will open, waiting for another session to invoke the program. When another session invokes the target, the debugger will display the code, allowing you to add break points, or step through line-by-line.
The other session is suspended until the debugging completes; then control is returned to the session. To use the debugger for direct debugging, right click on the name of the object that you wish to debug in the pgAdmin tree control and select Debug from the Debugging sub-menu.
The debugger window will open, prompting you for any values required by the program:. Use the Value field to provide the parameter value that will be passed to the program. PostgreSQL 8. Check the Use default? Provide values required by the program, and click the Debug button to start stepping through the program. The values of the arguments provided here are saved. The values will be pre-filled next time the dialog opens. To clear the values, use the Clear All button.
The main debugger window consists of two panels and a context-sensitive toolbar. Use toolbar icons to manage breakpoints and step into or through code; hover over an icon for a tooltip that identifies the option associated with the icon. The toolbar options are:.
Click the Step over icon to execute a line of code, stepping over any sub-functions invoked by the code. The sub-function executes, but is not debugged unless it contains a breakpoint. Use the Toggle breakpoint icon to enable or disable a breakpoint without removing the breakpoint.
The top panel of the debugger window displays the program body; click in the grey margin next to a line number to add a breakpoint. The highlighted line in the top panel is the line that is about to execute.
