BUG #14043: log_line_prefix %h not expand.(RPM only)
The following bug has been logged on the website:
Bug reference: 14043
Logged by: Harada Toshi
Email address: harada.toshi@po.ntts.co.jp
PostgreSQL version: 9.5.0
Operating system: CentOS 7
Description:
Hi.
* I have installed PostgreSQL 9.5.0 with RPM.
$ rpm -qa | grep postgres
postgresql95-devel-9.5.0-2PGDG.rhel7.x86_64
postgresql95-9.5.0-2PGDG.rhel7.x86_64
postgresql95-contrib-9.5.0-2PGDG.rhel7.x86_64
postgresql95-server-9.5.0-2PGDG.rhel7.x86_64
postgresql95-libs-9.5.0-2PGDG.rhel7.x86_64
* Host name (% h) was set to log_line_prefix.
log_line_prefix='(%h) (%r) :'
* In addition, we set the log_connections = on.
* And, connected by Unix-Domain-Socket to PostgreSQL.
$ psql postgres
* At this time, but confirmed the server log of the (connection revcieved),
host name has become an empty without being expanded.
() (): LOG: connection received: host = [local]
* However, the message itself, that contains the [local].
* In addition, a source from the build (configure --prefix, --with-xml only)
of PostgreSQL 9.5.1 to, when the same operation, the host name is expanded.
([local]) ([local]): LOG: connection received: host = [local]
* Is this a 9.5.0 bug? Or "RPM version PostgreSQL" specific issues?
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Thu, Mar 24, 2016 at 6:49 PM, <harada.toshi@po.ntts.co.jp> wrote:
* Is this a 9.5.0 bug? Or "RPM version PostgreSQL" specific issues?
From 9.5.1 release notes:
http://www.postgresql.org/docs/9.5/static/release-9-5-1.html
Make %h and %r escapes in log_line_prefix work for messages emitted
due to log_connections (Tom Lane)
Previously, %h/%r started to work just after a new session had emitted
the "connection received" log message; now they work for that message
too.
--
Michael
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Hi.
Thank you very much.
It was understood that this is a problem in the PostgreSQL 9.5.0.
Michael Paquier <michael.paquier@gmail.com> wrote:
On Thu, Mar 24, 2016 at 6:49 PM, <harada.toshi@po.ntts.co.jp> wrote:
* Is this a 9.5.0 bug? Or "RPM version PostgreSQL" specific issues?
From 9.5.1 release notes:
http://www.postgresql.org/docs/9.5/static/release-9-5-1.htmlMake %h and %r escapes in log_line_prefix work for messages emitted
due to log_connections (Tom Lane)
Previously, %h/%r started to work just after a new session had emitted
the "connection received" log message; now they work for that message
too.
--
Michael
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs