diff options
author | Matthew Jordan <mjordan@digium.com> | 2014-07-16 13:55:36 +0000 |
---|---|---|
committer | Matthew Jordan <mjordan@digium.com> | 2014-07-16 13:55:36 +0000 |
commit | 03e9c598e5fe2274e0e171519c5ac52738c65b14 (patch) | |
tree | e532af6b6244b867b0f1470bc7cee7790b758a42 /configs | |
parent | fee789dddbe0fe5791d42773e2293b693624e961 (diff) |
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
Diffstat (limited to 'configs')
-rw-r--r-- | configs/cdr_pgsql.conf.sample | 7 | ||||
-rw-r--r-- | configs/cel_pgsql.conf.sample | 3 | ||||
-rw-r--r-- | configs/res_pgsql.conf.sample | 3 |
3 files changed, 8 insertions, 5 deletions
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 |