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

postgresql.pl script does not work for postgresql greate than 9.2

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Minor
    • None
    • Community Edition
    • Unix Agent
    • Ubuntu 16.04 LTS, Virtual Machine, Postgresql 9.5 Perl 5.22.1

    Description

      The unix-agent script "postgresql.pl" is not working on postgres 9.2 and above. From Postgresql 9.2 the "current_query" in pg_stat_activity was split to two columns "state" and "query" causing the postgresql.pl script bundled with observium to cast a "Execution failed" error message.
      Source: [https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.2#pg_stat_activity_and_pg_stat_replication.27s_definitions_have_changed
      ]
      The workaround would be to make a check for postgres version and have two different queries.

      Best Regards.

      Attachments

        Activity

          People

            sid3windr Tom Laermans
            mbits Mads Boye
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated: