Search Postgresql Archives

Re: PostgreSQL 9.6.1: Debug window does not load function sql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

Inline image 1



Thanks,

Shakti Singh

 

On Wed, Dec 14, 2016 at 9:45 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux