Thread: BUG #14043: log_line_prefix %h not expand.(RPM only)

BUG #14043: log_line_prefix %h not expand.(RPM only)

From
harada.toshi@po.ntts.co.jp
Date:
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?

Re: BUG #14043: log_line_prefix %h not expand.(RPM only)

From
Michael Paquier
Date:
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

Re: BUG #14043: log_line_prefix %h not expand.(RPM only)

From
Toshi Harada
Date:
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.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