Jeff escribió:
On Apr 26, 2008, at 8:40 AM, Martin Marques wrote:
Martin Marques escribió:
I'm re-writing documentation I have used in the past to give PG
courses, and at this moment I upgrading the information in my docs to
fit PG 8.3.
What I'm stuck with now is pgiomonitor, which seems to not work due
to the changes that happened between 8.1 (last time I used it) and 8.3.
Does anybody know if development is still going to be done, at least
to make it fit new versions of PostgreSQL?
If anybody is interested (I'm not a Perl expert), I changed the line
where is asks if stats_block_level is on, to track_counts.
Now it works for PG 8.3.
hey neat. I wrote that years ago and its been quite dusty.
It worked then so I had nothing else to add to it.
I haven't migrated to 8.3 yet so I didn't know it broke.
Can you send me a diff?
--- pgiomonitor 2005-04-07 13:10:23.000000000 -0300
+++ pgiomonitor-8.3 2008-04-26 09:38:11.000000000 -0300
@@ -124,7 +124,7 @@
$dbname =~ s/ [[:ascii:]]+//;
# Check to see if we have block stats enabled
-$blockOn = @{$db->selectcol_arrayref("show stats_block_level")}->[0];
+$blockOn = @{$db->selectcol_arrayref("show track_counts")}->[0];
if($blockOn ne "on")
{
print "ERROR: you need to enable stats_block_level in
postgresql.conf\n";
