Re: Enabling debugger plugin on pgAdmin III

Melvin,

I came to know that, the debugging feature works ONLY IF the function is in
pl/pgsql language. Just pay attention to choose that when you create the
function (if you are using the GUI to create the function), then you should
see the debug menu (both when you right click and the top menu) when you
select that function. I assumed you enabled the debugger plugin as
instructed in the installation notes (as posted earlier here as well). Good
luck!..

*M. Matt Dugan,*
*Developer,*

On Wed, Apr 8, 2015 at 12:25 PM, Melvin Davidson <melvin6925(at)yahoo(dot)com>
wrote:

> FWIW, I am confirming the same problem on Windows 7 Home Premium Service
> Pack 1
> PostgreSQL 9.2.10, compiled by Visual C++ build 1600, 32-bit
>
> Melvin Davidson
> Cell 720-320-0155
>
> Folk Alley - All Folk - 24 Hours a day
> www.folkalley.com
>
>
> ------------------------------
> *From:* M. Matt Dugan <matt(at)edgle(dot)com>
> *To:* pgadmin-support(at)postgresql(dot)org
> *Sent:* Tuesday, April 7, 2015 12:44 PM
> *Subject:* [pgadmin-support] Enabling debugger plugin on pgAdmin III
>
> Upon many attempts and hours of search on the help pages as well as the
> internet, I have not been successful to enable the debugger plugin on
> pgAdmin III on Windows 7. Here are the things I have done.
>
> 1) As suggested on C:\Program
> Files\PostgreSQL\9.3\doc\installation-notes.html; I edited the
> postgresql.conf file that was in the data directory as:
>
> shared_preload_libraries = '$libdir/plugin_debugger.dll' (I made sure to
> removed #) (I tried this both by editing the conf file manually and (in a
> separate trial) by using the GUI provided by pgAdmin.
>
> 2) I stopped and started the postgresql-x64-9.3 service (which
> successfully did). I restarted pgAdmin.
>
> 3) On the psql shell, I ran command 'show shared_preload_libraries' and I
> did see '$libdir/plugin_debugger.dll' there.
>
> 4) On the pgAdmin III, I ran the script '*CREATE EXTENSION pldbgapi;*',
> which created the module under 'Extensions'. Which also added 22 new
> functions.
>
> However, I am still unable to see the debug option in the context menu
> (see the screenshot below) of the functions, and the 'debugging' menu under
> 'tools' is still inactive.
>
> My current configuration is pgAdmin III: 1.18.1, PostGRE SQL 9.3.6 windows
> x64.
>
> I have also tried PostGRE SQL 9.4.1 (both 32 bit and 64 bit windows
> versions) prior to this (which included pgAdmin III 1.20 I believe).
>
> Thanks in advance,
>
> Ps. I also tried to attach a screenshot but the email system denied it.
>
> *Matt *
>
>
>
>