From 03e9c598e5fe2274e0e171519c5ac52738c65b14 Mon Sep 17 00:00:00 2001 From: Matthew Jordan Date: Wed, 16 Jul 2014 13:55:36 +0000 Subject: cel_pgsql, cdr_pgsql, res_config_pgsql: Add PostgreSQL application_name support This patch adds support for the PostgreSQL application_name connection setting. When the appropriate PostgreSQL module's configuration is set with an application name, the name will be passed to PostgreSQL on connection and displayed in the database's pg_stat_activity view, as well as in CSV logs. This aids in managing which applications/servers are connected to a PostgreSQL database, as well as tracing the activity of those connections. Review: https://reviewboard.asterisk.org/r/3591 ASTERISK-23737 #close Reported by: Gergely Domodi patches: pgsql_application_name.patch uploaded by Gergely Domodi (License 6610) git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@418755 65c4cc65-6c06-0410-ace0-fbb531ad65f3 --- configs/cdr_pgsql.conf.sample | 7 ++++--- configs/cel_pgsql.conf.sample | 3 ++- configs/res_pgsql.conf.sample | 3 ++- 3 files changed, 8 insertions(+), 5 deletions(-) (limited to 'configs') diff --git a/configs/cdr_pgsql.conf.sample b/configs/cdr_pgsql.conf.sample index 7a909105f..286baab42 100644 --- a/configs/cdr_pgsql.conf.sample +++ b/configs/cdr_pgsql.conf.sample @@ -10,6 +10,7 @@ ;dbname=asterisk ;password=password ;user=postgres -;table=cdr ;SQL table where CDRs will be inserted -;encoding=LATIN9 ; Encoding of logged characters in Asterisk -;timezone=UTC ; Uncomment if you want datetime fields in UTC/GMT +;appname=asterisk ; Postgres application_name support (optional). Whitespace not allowed. +;table=cdr ; SQL table where CDRs will be inserted +;encoding=LATIN9 ; Encoding of logged characters in Asterisk +;timezone=UTC ; Uncomment if you want datetime fields in UTC/GMT diff --git a/configs/cel_pgsql.conf.sample b/configs/cel_pgsql.conf.sample index cc9b9ff91..10e3285ec 100644 --- a/configs/cel_pgsql.conf.sample +++ b/configs/cel_pgsql.conf.sample @@ -64,4 +64,5 @@ ;dbname=asterisk ;password=password ;user=postgres -;table=cel ;SQL table where CEL's will be inserted +;table=cel ; SQL table where CEL's will be inserted +;appname=asterisk ; Postgres application_name support (optional). Whitespace not allowed. diff --git a/configs/res_pgsql.conf.sample b/configs/res_pgsql.conf.sample index b889244a7..015d68c13 100644 --- a/configs/res_pgsql.conf.sample +++ b/configs/res_pgsql.conf.sample @@ -12,12 +12,13 @@ dbport=5432 dbname=asterisk dbuser=asterisk dbpass=password +;dbappname=asterisk ; Postgres application_name support (optional). Whitespace not allowed. ; ; dbsock is specified as the directory where the socket file may be found. The ; actual socket is constructed as a combination of dbsock and dbport. For ; example, the values of '/tmp' and '5432', respectively, will specify a socket ; file of '/tmp/.s.PGSQL.5432'. -; +; ;dbsock=/tmp ; ; requirements - At startup, each realtime family will make requirements -- cgit v1.2.3