Menu
I am unable to enable debugging in pgAdmin4. I have performed the following: 1. checked $libdir 2. checked the locatin of plugin_debugger.dll 3. changed postgresql.conf and the database will not restart.
Any suggestions what have I done wrong?
597
If pgAdmin displays this message, there are two possible reasons for this: the database server isn't running - simply start it. the server isn't configured to accept TCP/IP requests on the address shown.
To generate the Explain or Explain Analyze plan of a query, click on Explain or Explain Analyze button in the toolbar. More options related to Explain and Explain Analyze can be selected from the drop down on the right side of Explain Analyze button in the toolbar.
1) Download Postgres installer from EnterpriseDB website, they bundle debugger plugin.
2) Make an entry in the postgresql.conf file,
On Unix like systems,
shared_preload_libraries = '$libdir/plugin_debugger.so'
On Windows systems,
shared_preload_libraries = '$libdir/plugin_debugger.dll'
3) Restart your Postgres instance.
4) You have to create pldbgapi Extension in your maintenance database.
Refer given steps,
Click on Save button.
5) Goto your plpgsql function and right click on it, you will see "Debug" option.
171
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
