Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-25915

PostgreSQL by Zabbix agent 2 throws errors on postgres 17

XMLWordPrintable

    • Sprint candidates

      Steps to reproduce:

      1. Setup PostgreSQL by Zabbix agent 2 in postgres 17
      2. On the postgres logs

               SELECT row_to_json (T) 
           FROM ( 
                 SELECT 
                     checkpoints_timed 
                   , checkpoints_req 
                   , checkpoint_write_time 
                   , checkpoint_sync_time 
                   , buffers_checkpoint 
                   , buffers_clean 
                   , maxwritten_clean 
                   , buffers_backend 
                   , buffers_backend_fsync 
                   , buffers_alloc 
                 FROM pg_catalog.pg_stat_bgwriter 
                         ) T ;

      According to https://pgpedia.info/p/pg_stat_bgwriter.html

      From PostgreSQL 17, following pg_stat_bgwriter columns are incorporated into pg_stat_checkpointer:{}

      So the postgres plugin should adapt to those new versions

        1. image-2025-01-24-10-04-26-802.png
          5 kB
          Jan Prusinowski
        2. image-2025-01-24-10-05-07-839.png
          57 kB
          Jan Prusinowski
        3. image-2025-01-24-11-07-51-446.png
          56 kB
          Jan Prusinowski

            esneiders Eriks Sneiders
            aseques Joan
            Team INT
            Votes:
            2 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated: