[ZBXNEXT-2206] Use/set "application_name" for connections with PostgreSQL backend Created: 2014 Mar 15  Updated: 2014 Mar 29

Status: Open
Project: ZABBIX FEATURE REQUESTS
Component/s: Frontend (F), Proxy (P), Server (S)
Affects Version/s: 2.0.11
Fix Version/s: None

Type: Change Request Priority: Trivial
Reporter: Marc Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: database, postgresql
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File application_name.png    

 Description   

What about setting "application_name" for connections to PostgreSQL based database backends?
See: http://www.postgresql.org/docs/9.3/static/runtime-config-logging.html#GUC-APPLICATION-NAME

This might allow better differentiation between sessions from frontend, server, users, ...
Especially when there is one database user for any component, what probably is the case for most installations due to lack of ZBX-7604

Any Zabbix component should have a dedicated "application_name" possibly honoring the optional "Installation name" ( https://www.zabbix.com/documentation/2.2/manual/installation#step_4 )

Of course this would be valuable for any database backend that support this kind of functionality.

 Comments   
Comment by richlv [ 2014 Mar 16 ]

note that zabbix server uses lowercase sql statements, frontend uses uppercase

Comment by Marc [ 2014 Mar 16 ]

That should rather be aligned to be uniform

Comment by Oleksii Zagorskyi [ 2014 Mar 16 ]

From a zabbix user on oracle I know that they are able to distinguish db connections: form server or frontend.
Not sure is it specifically configured or by default on oracle but it's useful for troubleshooting.

Comment by Marc [ 2014 Mar 16 ]

Probably via the PROGRAM column of V$SESSION.
I believe it gets set by content of /proc/self/cmdline.

Comment by richlv [ 2014 Mar 17 ]

i meant that uppercase/lowercase in statements allows to distinguish server/frontend queries already on all databases

Comment by Marc [ 2014 Mar 29 ]

Yeah, I had understood You correctly. Imho the use of capital and small letters should be uniform over all components.

Generated at Fri Apr 26 17:50:38 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.