Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 322249FBD74 for ; Fri, 6 Apr 2007 16:36:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 20285-01-3 for ; Fri, 6 Apr 2007 16:36:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by postgresql.org (Postfix) with ESMTP id 78EF89FBDE4 for ; Fri, 6 Apr 2007 16:36:00 -0300 (ADT) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 5F0C1118A3E; Fri, 6 Apr 2007 15:35:59 -0400 (EDT) Date: Fri, 6 Apr 2007 15:35:59 -0400 From: Ray Stell To: pgsql-admin@postgresql.org Subject: alter user log entry, too much information ;) Message-ID: <20070406193559.GA27920@cns.vt.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/61 X-Sequence-Number: 25125 8.2.3 I did an alter user: template1=# alter user myadminuserid encrypted password 'myadminuseridpw'; which cut the this log entry: template1,21579,myadminuserid,2007-04-06 15:11:19.575 EDT,46169b35.544b,3,2007-04-06 15:10:45 EDT,594,idle LOG: statement: alter user myadminuserid encrypted password 'myadminseridpw'; seems like the encrypted version of 'myadminseridpw' would be a good idea in the log. Is there away to config that?