From 497ae0b60cc84b9646376ed312c483f7828f9ab5 Mon Sep 17 00:00:00 2001 From: Marcin Krol Date: Mon, 3 Dec 2018 13:39:01 +0000 Subject: [PATCH] - use full name in syslog ident, updated default logging config --- postgresql-conf.patch | 29 ++++++++++++++++++----------- postgresql.spec | 2 +- 2 files changed, 19 insertions(+), 12 deletions(-) diff --git a/postgresql-conf.patch b/postgresql-conf.patch index 8db0a1f..6a4c292 100644 --- a/postgresql-conf.patch +++ b/postgresql-conf.patch @@ -1,6 +1,6 @@ ---- postgresql-8.3RC1/src/backend/utils/misc/postgresql.conf.sample.orig 2007-12-07 16:44:56.000000000 +0000 -+++ postgresql-8.3RC1/src/backend/utils/misc/postgresql.conf.sample 2008-01-07 22:19:56.904649611 +0000 -@@ -253,7 +253,7 @@ +--- postgresql-9.3.25/src/backend/utils/misc/postgresql.conf.sample 2018-11-05 21:53:28.000000000 +0000 ++++ postgresql-9.3.25/src/backend/utils/misc/postgresql.conf.sample 2018-12-03 13:37:57.846403000 +0000 +@@ -291,7 +291,7 @@ # - Where to Log - @@ -9,23 +9,30 @@ # stderr, csvlog, syslog, and eventlog, # depending on platform. csvlog # requires logging_collector to be on. -@@ -262,8 +262,8 @@ - # 0 to disable. +@@ -324,8 +324,8 @@ + # 0 disables. # These are relevant when logging to syslog: -#syslog_facility = 'LOCAL0' -#syslog_ident = 'postgres' +syslog_facility = 'LOCAL0' -+syslog_ident = 'postgres-9.3' ++syslog_ident = 'postgresql-9.3' - - # - When to Log - -@@ -324,7 +324,7 @@ + # This is only relevant when logging to eventlog (win32): + # (change requires restart) +@@ -385,12 +385,12 @@ #debug_print_plan = off - #debug_pretty_print = off + #debug_pretty_print = on #log_checkpoints = off -#log_connections = off +-#log_disconnections = off +log_connections = on - #log_disconnections = off ++log_disconnections = on #log_duration = off + #log_error_verbosity = default # terse, default, or verbose messages #log_hostname = off +-#log_line_prefix = '' # special values: ++log_line_prefix = '%m [%p] %q%h/%a %u/%d ' # special values: + # %a = application name + # %u = user name + # %d = database name diff --git a/postgresql.spec b/postgresql.spec index 9cad3d4..5c59572 100644 --- a/postgresql.spec +++ b/postgresql.spec @@ -29,7 +29,7 @@ Summary(uk.UTF-8): PostgreSQL - система керування базами Summary(zh_CN.UTF-8): PostgreSQL 客户端程序和库文件 Name: postgresql-%{pgsqlversion} Version: %{pgsqlversion}.25 -Release: 1 +Release: 2 License: BSD Group: Applications/Databases Source0: http://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2 -- 2.46.0