[ZBX-20090] PostgreSQL 9.6 - Column "backend_type" does not exist Created: 2021 Oct 15  Updated: 2024 May 22  Resolved: 2024 May 22

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Templates (T)
Affects Version/s: 5.0.16
Fix Version/s: None

Type: Incident report Priority: Trivial
Reporter: Robson Jorge Fernandez Assignee: Aleksandre Sebiskveradze (Inactive)
Resolution: Unsupported version Votes: 0
Labels: items, templates
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Red Hat Enterprise Linux Server release 6.10 (Santiago)
2.6.32-754.23.1.el6.x86_64

PostgreSQL was install from repo https://download.postgresql.org

  1. psql --version
    psql (PostgreSQL) 9.6.23

Attachments: Text File details.txt    

 Description   

Steps to reproduce:

  1. Install/Configure the template 
  2. Try to execute the user parameter pgsql.transactions

 

Result:
The following error show when execute the item __ pgsql.transactions:

psql:/var/lib/zabbix/externalscripts/postgresql/pgsql.transactions.sql:28: ERROR: column "backend_type" does not exist

 

 
Generated at Fri Jun 13 05:08:38 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.