0

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 ?

Marut Singh
  • 345
  • 1
  • 3
  • 10
  • Here is similar question. http://stackoverflow.com/questions/20190406/how-to-debug-postgresql-stored-procedures – parlad May 02 '17 at 02:35

1 Answers1

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.

Laurenz Albe
  • 209,280
  • 17
  • 206
  • 263