Hello, I'm having some issues using the debugger and the profiler.
My setup is as follows. DB Server setup: DB server running FreeBSD 6.2 database 8.3 Beta2 Client setup: Windows Vista pgAdmin III v1.8.0 Problem #1: When I have both the debugger and profiler modules setup to load in my postgresql.conf file I can't get the debugger to work. If I right click on a function and click debug a parameter window pops up that allows me to click on it and nothing happens, so I'm not able to debug and functions. If I remove the profiler module from loading and restart postgresql the debugger works fine. When I do have both loading the log message shows they load fine so it doesn't appear to be a issue with getting them both to load. Problem #2: I can't get the profiler to give me IO stats. It gives me the basic stats as described in the readme(README.plprofiler) . It says to apply a patch to get the IO stats. So I tried this and the profiler works but I get no IO stats. Here is the output from my patch attempt. As you can see not everything seemed to patch correctly which probably is why the IO stats is not working. So my question should probably be why doesn't the patch work. I downloaded it from http://pgfoundry.org/projects/edb-debugger . ----START PATCH OUTPUT---- [EMAIL PROTECTED] ~/postgresql-8.3beta2]$ patch < profilerPatch83.diff Hmm... Looks like a new-style context diff to me... The text leading up to this was: -------------------------- |Index: src/include/pgstat.h |=================================================================== |RCS file: /projects/cvsroot/pgsql/src/include/pgstat.h,v |retrieving revision 1.64 |diff -c -r1.64 pgstat.h |*** src/include/pgstat.h 8 Jul 2007 22:23:16 -0000 1.64 |--- src/include/pgstat.h 9 Aug 2007 14:33:09 -0000 -------------------------- Patching file src/include/pgstat.h using Plan A... Hunk #1 failed at 506. 1 out of 1 hunks failed--saving rejects to src/include/pgstat.h.rej Hmm... The next patch looks like a new-style context diff to me... The text leading up to this was: -------------------------- |Index: src/backend/postmaster/pgstat.c |=================================================================== |RCS file: /projects/cvsroot/pgsql/src/backend/postmaster/pgstat.c,v |retrieving revision 1.162 |diff -c -r1.162 pgstat.c |*** src/backend/postmaster/pgstat.c 2 Aug 2007 23:39:44 -0000 1.162 |--- src/backend/postmaster/pgstat.c 9 Aug 2007 14:33:10 -0000 -------------------------- Patching file src/backend/postmaster/pgstat.c using Plan A... Hunk #1 succeeded at 157 (offset -2 lines). Hunk #2 succeeded at 1242 (offset -40 lines). Hunk #3 failed at 1267. Hunk #4 succeeded at 1335 (offset 1 line). 1 out of 4 hunks failed--saving rejects to src/backend/postmaster/pgstat.c.rej done ---END PATCH OUTPUT--- Here is the contents of pgstat.c.rej if that helps. I'm not a c programmer so I pretty much just follow the directions for this type of thing and hope for it to just work. ---START pgstat.c.rej--- *************** *** 1264,1269 **** /* t_tuples_updated is nontransactional, so just advance it */ pgstat_info->t_counts.t_tuples_updated++; /* We have to log the transactional effect at the proper level */ if (pgstat_info->trans == NULL || --- 1267,1273 ---- /* t_tuples_updated is nontransactional, so just advance it */ pgstat_info->t_counts.t_tuples_updated++; + pgStatGlobals.t_tuples_updated++; /* We have to log the transactional effect at the proper level */ if (pgstat_info->trans == NULL || ---END pgstat.c.rej--- Any ideas of what might be wrong or if I'm doing something wrong? I appreciate any help on this. Thanks, Bob
