[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: | application_name.png |
Description |
What about setting "application_name" for connections to PostgreSQL based database backends? This might allow better differentiation between sessions from frontend, server, users, ... 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. |
Comment by Marc [ 2014 Mar 16 ] |
Probably via the PROGRAM column of V$SESSION. |
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. |