[ZBX-23374] Postgresql logs: Role "zabbix" does not exist Created: 2023 Sep 07  Updated: 2023 Sep 08  Resolved: 2023 Sep 08

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Agent (G)
Affects Version/s: 6.0.21
Fix Version/s: None

Type: Problem report Priority: Trivial
Reporter: Andrea Davanzo Assignee: Zabbix Support Team
Resolution: Won't fix Votes: 0
Labels: bug
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File Screenshot 2023-09-08 at 12.28.23.png     PNG File image-2023-09-08-11-23-25-099.png    

 Description   

Steps to reproduce:

  1. Installed Zabbix Agent 6.0.21 on Ubuntu 18.04 and configured client and PostgreSQL 11.20
  2. Add template to the host into Zabbix server
  3. Followed 100% instruction on Zabbix website

Result:
Data are collected and visible on Zabbix server, however Postgresql server shows on log:

2023-09-07 19:51:03.192 UTC [11251] zabbix@zabbix FATAL:  role "zabbix" does not exist
2023-09-07 19:52:03.146 UTC [11408] zabbix@zabbix FATAL:  role "zabbix" does not exist
2023-09-07 19:53:03.114 UTC [11564] zabbix@zabbix FATAL:  role "zabbix" does not exist
2023-09-07 19:54:03.248 UTC [11720] zabbix@zabbix FATAL:  role "zabbix" does not exist
.....

Expected:

There should not be any error because the user is zbx_monitor and not zabbix.

PostgreSQL 11.20 (Ubuntu 11.20-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit)

 Comments   
Comment by dimir [ 2023 Sep 08 ]

Did you carefully follow instructions on download page?

Comment by Andrea Davanzo [ 2023 Sep 08 ]

Hi @dimir,

very likely my description is not clear, sorry for this.

My Zabbix server is working perfectly and I have installed Zabbix Agent  for Ubuntu 18.04 with postgreSQL on a server I want to monitor. Zabbix agent has been downloaded from Zabbix website.

I followed the instruction on https://www.zabbix.com/integrations/postgresql

I see the data on Zabbix server, however on the postgreSQL server I see this entries:

 

The question are:

  • who/what check is connecting as user "zabbix"? Template and setup are using "zbx_monitor".
  • Is there any way to increase the verbosity of Zabbix agent in order to see what exactly are all the command its performing?

Thanks

Comment by dimir [ 2023 Sep 08 ]

OK, got you. Look, this seems to be about something else than Zabbix bug or feature request. This issue tracker is only served for those purposes so I suggest you to report your issue in Zabbix forum or use any other ways to get help from Zabbix community. Alternatively you might consider Zabbix commercial support to get help from professionals.

That said, I'm going to close the ticket. Feel free to re-open is you disagree.

Comment by Andrea Davanzo [ 2023 Sep 08 ]

Thanks @dimir.

I feel that this is a Zabbix bug. The template used comes from Zabbix and not a third parties. Instructions comes from official Zabbix.

Maybe that no one developer spotted these  entries on postgreSQL and focused only on see the data appears on Zabbix server.

I'll post on Zabbix forum  and let's see the result.

Keep it closed.

Cheers

Generated at Tue Aug 05 23:46:28 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.