Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 7BC19632755 for ; Wed, 26 May 2010 18:08:43 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 26099-06 for ; Wed, 26 May 2010 21:08:35 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by mail.postgresql.org (Postfix) with ESMTP id 734B9632514 for ; Wed, 26 May 2010 18:08:35 -0300 (ADT) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 6F90B118969; Wed, 26 May 2010 17:08:33 -0400 (EDT) Date: Wed, 26 May 2010 17:08:33 -0400 From: Ray Stell To: pgsql-admin@postgresql.org Subject: command tag logging Message-ID: <20100526210833.GA14469@cns.vt.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/257 X-Sequence-Number: 34730 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 befo= re on connection received lines as if it is dumping the environment: [unknown],17462,[unknown],2010-05-26 16:04:33.293 EDT,4bfd7ed1.4436,1,2010-= 05-26 16:04:33 EDT,0,/usr/local/pgsql8311/bin/postgres-D/var/database/pgsql= /alerts_subscribeMANPATH=3D/usr/local/pgsql/man:HOSTNAME=3Dtest.cns.vt.eduT= ERM=3DxtermSHELL=3D/bin/bashHISTSIZE=3D1000ANT_HOME=3D/var/local/apache-ant= USER=3DpostgresqlLS_COLORS=3Dno=3D00:fi=3D00:di=3D00;34:ln=3D00;36:pi=3D40;= 33:so=3D00;35:bd=3D40;33;01:cd=3D40;33;01:or=3D01;05;37;41:mi=3D01;05;37;41= :ex=3D00;32:*.cmd=3D00;32:*.exe=3D00;32:*.com=3D00;32:*.btm=3D00;32:*.bat= =3D00;32:*.sh=3D00;32:*.csh=3D00;32:*.tar=3D00;31:*.tgz=3D00;31:*.arj=3D00;= 31:*.taz=3D00;31:*.lzh=3D00;31:*.zip=3D00;31:*.z=3D00;31:*.Z=3D00;31:*.gz= =3D00;31:*.bz2=3D00;31:*.bz=3D00;31:*.tz=3D00;31:*.rpm=3D00;31:*.cpio=3D00;= 31:*.jpg=3D00;35:*.gif=3D00;35:*.bmp=3D00;35:*.xbm=3D00;35:*.xpm=3D00;35:*.= png=3D00;35:*.tif=3D00;35:LD_LIBRARY_PATH=3D/usr/lib/openssl/:/usr/local/pg= sql/lib:PATH=3D/usr/java/jdk1.6.0_20/bin:/usr/kerberos/bin:/usr/local/bin:/= bin:/usr/bin:/db03/app/oracle/product/11.1.0/bin:/var/local/apache-ant/bin:= /usr/local/maven/bin:/usr/local/pgsql/binMAIL=3D/var/spool/mail/postgresql_= =3D/usr/local/pgsql8311/bin/postgresPWD=3D/home/postgresqlINPUTRC=3D/etc/in= putrcJAVA_HOME=3D/usr/java/jdk1.6.0_20LANG=3Den_US.UTF-8PGSYSCONFDIR=3D/usr= /local/pgsql8311/etcSSH_ASKPASS=3D/usr/libexec/openssh/gnome-ssh-askpassPGD= IR=3D/usr/local/pgsqlHOME=3D/home/postgresqlSHLVL=3D2M2_HOME=3D/usr/local/m= avenLOGNAME=3DpostgresqlCVS_RSH=3D/usr/bin/sshPGDATA=3D/var/database/pgsql/= alerts_subscribeLESSOPEN=3D|/usr/bin/lesspipe.sh %sORACLE_HOME=3D/db03/app/= oracle/product/11.1.0G_BROKEN_FILENAMES=3D1 LOG: connection received: host= =3D198.82.3.23 port=3D49723 I took the $i out of the mix for now: =20 [unknown],17469,[unknown],2010-05-26 16:05:18.312 EDT,4bfd7efe.443d,1,2010-= 05-26 16:05:18 EDT,0 LOG: connection received: host=3D198.82.41.41 port=3D= 49707 Is this repeatable elsewhere? Thanks.