Re: command tag logging

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: alvherre <alvherre(at)commandprompt(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: command tag logging
Date: 2010-05-27 17:25:47
Message-ID: 20100527172547.GA9472@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

On Thu, May 27, 2010 at 12:49:49PM -0400, Tom Lane wrote:
> alvherre <alvherre(at)commandprompt(dot)com> writes:
> > Excerpts from Ray Stell's message of mi may 26 17:08:33 -0400 2010:
> >> I just installed a compiled from src 8.3.11. I usually include %i, command tag,
> >> in the log_line_prefix setting. This causes some spewage I'd not seen before
> >> on connection received lines as if it is dumping the environment:
>
> > Hmm, I bet it's the recent %.*s patch.
>
> That is in the right place, isn't it. That would suggest that
> get_ps_display() is returning a wrong length on Ray's machine.
> It works okay here, but since that's platform-specific code that
> hardly proves much. Ray, what platform is this exactly?

I should have included this:

version
-----------------------------------------------------------------------------------------------------
PostgreSQL 8.3.11 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46)
(1 row)

[postgres ~]$ uname -a
Linux horntail.cns.vt.edu 2.6.18-194.3.1.el5PAE #1 SMP Sun May 2 04:42:25 EDT 2010 i686 i686 i386 GNU/Linux

[postgres ~]$ cat /etc/issue
Red Hat Enterprise Linux Server release 5.5 (Tikanga)
Kernel \r on an \m

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Josh Berkus 2010-05-27 18:11:51 Re: List traffic
Previous Message Tom Lane 2010-05-27 17:15:25 Re: command tag logging

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2010-05-27 17:26:26 Re: Keepalive for max_standby_delay
Previous Message Tom Lane 2010-05-27 17:15:25 Re: command tag logging