Обсуждение: easy enabling of debugging on Windows?
I've been trying to find a way to debug my PL/Pgsql functions. The one click 8.3 installer doesn't create a \contrib directory and although I found and downloaded the appropriate files I don't know how to make them. I even tried an alternate front end admin tool and it won't work either without 'the corresponding Postgresql server module'. Shouldn't it be easier than this? I want to build functionality not spend a day and a half trying to find and install a debugger! Why isn't it included as part of the install. -- View this message in context: http://www.nabble.com/easy-enabling-of-debugging-on-Windows--tp22348851p22348851.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
On Thu, Mar 5, 2009 at 11:21 AM, woodcock <woodcocs@hotmail.com> wrote: > > I've been trying to find a way to debug my PL/Pgsql functions. The one click > 8.3 installer doesn't create a \contrib directory and although I found and > downloaded the appropriate files I don't know how to make them. I even > tried an alternate front end admin tool and it won't work either without > 'the corresponding Postgresql server module'. > Shouldn't it be easier than this? > I want to build functionality not spend a day and a half trying to find and > install a debugger! Why isn't it included as part of the install. While you have a point, it has nothing to do with pgAdmin itself. Did you follow instructions from http://pginstaller.projects.postgresql.org/ ? Please take a close look at paragraph 8, Contrib modules. Cheers, Marcin
On Thu, Mar 5, 2009 at 10:21 AM, woodcock <woodcocs@hotmail.com> wrote: > > I've been trying to find a way to debug my PL/Pgsql functions. The one click > 8.3 installer doesn't create a \contrib directory and although I found and > downloaded the appropriate files I don't know how to make them. The contrib directory I think you're referring to is in the source tree, not the binary releases. The one click installer includes the debugger plugin pre-compiled and ready to use. All you need to do is stick: shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' In postgresql.conf, and restart the server. Then, run the SQL script in the database you wish to debug in and reconnect pgAdmin. On double checking the installer, it does seem the SQL script has got lost somehow - I'll get that fixed ASAP. In the meantime, you can get the script here: http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/edb-debugger/server/pldbgapi.sql?rev=1.2 -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
> The one click installer includes the debugger plugin pre-compiled and > ready to use. All you need to do is stick: > > shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' > > In postgresql.conf, and restart the server. Then, run the SQL script > in the database you wish to debug in and reconnect pgAdmin. > > On double checking the installer, it does seem the SQL script has got > lost somehow - I'll get that fixed ASAP. In the meantime, you can get > the script here: > http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/edb-debugger/server/pldbgapi.sql?rev=1.2 > > -- > Dave Page > EnterpriseDB UK: http://www.enterprisedb.com > Hey Dave, Thanks for the prompt response which worked. I can now debug in pgAdmin. Hopefully other Windows users will find your easy solution (which I've not seen elsewhere.) -- View this message in context: http://www.nabble.com/easy-enabling-of-debugging-on-Windows--tp22348851p22351282.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
On Thu, Mar 5, 2009 at 1:07 PM, woodcock <woodcocs@hotmail.com> wrote: > > Thanks for the prompt response which worked. I can now debug in pgAdmin. Glad to help. > Hopefully other Windows users will find your easy solution (which I've not > seen elsewhere.) It's in the installation notes - see Start->Programs->PostgreSQL 8.3->Documentation->Installation Notes. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com