Thanks Adrian, Yes, I did all this. The OS is Windows 2012 R2 64 bit.
I am logging in using postgres user, which is the super user for the database. The shared_preload_libraries = '$libdir/plugin_debugger' (The dll resides in the "lib" directory) I restarted the server by restarting the service "postgresql-x64-9.6 - PostgreSQL Server 9.6" Here is the screenshot of the right hand pane when: 1. I select a plpgsql function 2. right click and select Debugging > Debug 3. Fill in the parameter values in the pop up [image: Inline image 1] Thanks, Shakti Singh On Wed, Dec 14, 2016 at 9:45 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 12/14/2016 05:19 AM, Shakti Singh wrote: > >> Hi, >> >> I am working on a POC to port Oracle database to PostGreSQL. >> I am trying to debug a function in pgAdmin 4 after enabling debugger. >> >> The Debugger window that opens in pgAdmin 4 for a function does not show >> any function code because of which I cannot put a break point. >> >> > Does all of the below apply to your situation?: > > https://www.pgadmin.org/docs4/dev/debugger.html > > "The debugger may be used to debug PL/pgSQL functions in PostgreSQL, as > well as EDB-SPL functions, stored procedures and packages in Advanced > Server. The Debugger is available as an extension for your PostgreSQL > installation, and is distributed as part of Advanced Server. You must have > superuser privileges to use the debugger. > > Before using the debugger, you must modify the postgresql.conf file, > adding the server-side debugger components to the the value of the > shared_preload_libraries parameter: > > shared_preload_libraries = ‘$libdir/other_libraries/plugin_debugger’ > > After modifying the shared_preload_libraries parameter, restart the server > to apply the changes." > > > > > Any help is appreciated. >> >> Thanks >> >> Shakti Singh >> >> > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
