Re: status on pgiomonitor

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";