FWIW, I am confirming the same problem on Windows 7 Home Premium Service Pack
1PostgreSQL 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 <[email protected]>
To: [email protected]
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