Re: PL/pgSQL debugger

You did not indicate which O/S you are using, but here are the detailed
instructions for Windows.

http://blog.databasepatterns.com/2014/01/installing-debugger-for-pgadmin-on.html

Note that the most important part is to load the .dll in postgresql.conf.

shared_preload_libraries = '$libdir/plugin_debugger.dll'

This should also work for Linux, providing you have the .dll

On Fri, Jan 29, 2016 at 4:02 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
wrote:

> Hi
>
> 2016-01-29 21:52 GMT+01:00 Dane Foster <studdugie(at)gmail(dot)com>:
>
>> Hello,
>>
>> I googled "plpgsql debugger" and eventually ended up at
>> http://pgfoundry.org/projects/edb-debugger/, where the latest release is
>> almost 8 years old. I am aware that this is not an EDB forum but given that
>> I sent them an e-mail at 9AM EST and I haven't received a response yet I
>> figured it can't hurt to try my question here. Is anyone using it on recent
>> (e.g., 9.5) versions of PostgreSQL. If not, is there any consensus on what
>> one should be using to debug PL/pgSQL functions?
>>
>
> plpgsql debugger should be included directly in pgAdminIII
>
> The necessary extension can 8 years old - it implements communication
> between client and server side code and this is long time without change
>
> http://www.pgadmin.org/docs/1.8/debugger.html
>
> Regards
>
> Pavel
>
>
>> Thanks,
>>
>> Dane
>>
>
>

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.