Trouble using debugger and profiler - Mailing list pgadmin-support

From Bob
Subject Trouble using debugger and profiler
Date
Msg-id 762e5c0711011223m23c880fdr1bac5d2b6f188400@mail.gmail.com
Whole thread Raw
List pgadmin-support

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----
[xyz@greatwhite ~/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

pgadmin-support by date:

Previous
From: Raphaël Enrici
Date:
Subject: Re: pgAdmin III 1.8.0 for debian etch uploaded.
Next
From: Raphaël Enrici
Date:
Subject: Re: Where can I get your public key?