On Fri, May 16, 2008 at 1:32 PM, Robert Fitzpatrick <lists@webtent.net> wrote:
> I have built posgresql 8.3.1 on a FreeBSD 6.1 via the ports system
> WITH_DEBUG=true and also on a Windows machine with the debugger
> selected. I see the plugin_debugger.dll under the lib/plugins folder on
> the Windows machine as well. But when I look for the procs, they are not
> there....
>
> template1=# select * from pg_proc where proname like 'pldbg%';
> proname | pronamespace | proowner | prolang | procost | prorows | proisagg | prosecdef | proisstrict | proretset | provolatile | pronargs | prorettype | proargtypes | proallargtypes | proargmodes | proargnames | prosrc | probin | proconfig | proacl
> ---------+--------------+----------+---------+---------+---------+----------+-----------+-------------+-----------+-------------+----------+------------+-------------+----------------+-------------+-------------+--------+--------+-----------+--------
> (0 rows)
>
> Can someone help or point me to some docs that can tell me what else I
> need to do to enable debugging plpgsql?

There is a README with the plugin which tells you how to modify
postgresql.conf to preload the libraries at server start (which you
must do). Once you've done that, just run the pldbgapi.sql script
that's also included to load the api functions into the database you
wish to debug.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On Fri, 2008-05-16 at 14:27 +0100, Dave Page wrote:
> There is a README with the plugin which tells you how to modify
> postgresql.conf to preload the libraries at server start (which you
> must do). Once you've done that, just run the pldbgapi.sql script
> that's also included to load the api functions into the database you
> wish to debug.
>

Thanks for the help, I guess this is my problem. I do not have anything
in the Windows server plugins folder except plugin_debugger.dll and
plugin_profiler.dll. On the FreeBSD box, cannot find plugin_debugger.so
anywhere or the pldbgapi.sql script on either server. More suggestions?

I did find this link, so I believe I know how to get it setup once I get
the needed lib and script files...

http://cvs.pgfoundry.org/cgi-bin/cvs...-cvsweb-markup


--
Robert


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general