CODEWITHSUNDEEP
postgresqlpostgresql-9.5
Marut Singh
Marut Singh

Reputation: 355

Postgresql stored procedure debug

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 ?

Upvotes: 0

Views: 424

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246493

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.

Upvotes: 1

Related Questions