Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-1910

UNIX agent Postgres versions

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Trivial
    • None
    • None
    • Unix Agent
    • Linux, PostgreSQL

    Description

      This issue is based on the mailing list thread with the same subject from 2016-01-05.
      Below I included an excerpt of the posts:
      -SNIP---------------------------
      I was in the process of configuring the UNIX agent and I found (as written in the documentation too) that the script only supports Postgres version 9.
      But after experimenting a little bit I realized that the script works perfectly with the 8.4 version. I was able to test with an 8.3 which was working as well.
      So maybe the script should be changed to enable any 8.X version.
      -SNIP-------------
      Reading the documentation, I did find out that the tuples stats collection was added in version 8.3, so I changed my file (patch attached).
      And indeed, testing on 8.3 and 8.4 everything works perfectly, it can find and extract every information, on an older server that has 8.1 installed, it simply doesn't aggregate tuples data.
      I didn't put time in investigating older versions as they are really obsolete.

      I didn't know which is the proper way to fix the output:

      • output all zero values for the tuples stats
      • don't output anything at all for nonexistent values
        so I decided I would go with the second choice. This is reflected in my patch.

      I added a small remark in the header of the file to indicate the version peculiarities.
      The web page should be updated as well
      -SNIP---------------------------

      Attachments

        Activity

          People

            sid3windr Tom Laermans
            tylla Nagy Attila
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: