Обсуждение: Installing debugger
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? -- Robert
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
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/cvsweb.cgi/edb-debugger/server/Attic/pldebugger.README?rev=1.1&content-type=text/x-cvsweb-markup -- Robert
The readme should be in/under the doc directory of your installation, and the script in the share directory. On 5/16/08, Robert Fitzpatrick <lists@webtent.net> wrote: > 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/cvsweb.cgi/edb-debugger/server/Attic/pldebugger.README?rev=1.1&content-type=text/x-cvsweb-markup > > > -- > Robert > > -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com