Re: status on pgiomonitor - Mailing list pgsql-general

From Martin Marques
Subject Re: status on pgiomonitor
Date
Msg-id 48161443.4060009@marquesminen.com.ar
Whole thread Raw
In response to Re: status on pgiomonitor  (Jeff <threshar@torgo.978.org>)
List pgsql-general
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";


pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: varchar or text
Next
From: Tino Wildenhain
Date:
Subject: Re: How to modify ENUM datatypes?