Re: cannot get Debugger to install on 9.2 on Win7 x-64

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Tim Romano <tim(dot)romano888(at)gmail(dot)com>
Cc: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: cannot get Debugger to install on 9.2 on Win7 x-64
Date: 2013-02-07 08:53:50
Message-ID: CA+OCxoyDjkb=nAtyKO9yWp0VJnZKhpeW7hqHaQzopuFom0hELg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Wed, Feb 6, 2013 at 7:58 PM, Tim Romano <tim(dot)romano888(at)gmail(dot)com> wrote:
> I followed the steps to enable the debugger:
>
> 1. Modified the postgresql.conf file as directed shared_preload_libraries =
> '$libdir/plugin_debugger.dll'
> 2. Stopped and restarted the database service.
> 3. Ran CREATE EXTENSION pldbgapi in the database where I'm writing the
> functions. It reported success.
>
> But the debug option does show up in the Tools menu, nor does it appear in
> the treeview's context-menu when I right-click on a function-name.

I'm sure people are getting sick of me saying this here, but it worked
for me! Some things to check:

- Did you restart pgAdmin (or at least disconnect and reconnect the
server) after creating the extension?

- The debugger only supports pl/pgsql functions on PostgreSQL. Are you
right-clicking a function written in a different language?

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2013-02-07 09:08:06 Re: PgAgent 3.3.0 batch scripts on windows always get status failed
Previous Message Tim Romano 2013-02-06 19:58:26 cannot get Debugger to install on 9.2 on Win7 x-64