Postgresql stored procedure debug

Question

I am trying to find on net and it seems that there is a plugin I need to install which will enable a debug option in pgadmin3 but I can't see any such option.. How can I debug Postgresql stored procedure ?

Here is similar question. stackoverflow.com/questions/20190406/… — parlad
– parlad, Commented May 2, 2017 at 2:35

Laurenz Albe · Accepted Answer · 2017-05-02 09:26:41Z

1

You'll have to install the pldebugger on the PostgreSQL server.

After you have compiled and installed the extension, you must add plugin_debugger to shared_preload_libraries in postgresql.conf and restart the database server.

Then you can debug functions with pgAdmin.

answered May 2, 2017 at 9:26

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql stored procedure debug

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related