pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Ray Stell <stellr@cns.vt.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: alter user log entry, too much information ;)
Date: Fri, 6 Apr 2007 18:08:27 -0400
Message-ID: <20070406220827.GG8209@alvh.no-ip.org> (raw)
In-Reply-To: <20070406193559.GA27920@cns.vt.edu>
References: <20070406193559.GA27920@cns.vt.edu>

Ray Stell wrote:
> 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?  

No, but if you're going to do it in psql you can use \password.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.



view thread (2+ messages)

Message-ID: <20070406220827.GG8209@alvh.no-ip.org>
Permalink:  ../20070406220827.GG8209@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20070406220827.GG8209@alvh.no-ip.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: alvherre@commandprompt.com, stellr@cns.vt.edu
  Subject: Re: alter user log entry, too much information ;)
  In-Reply-To: <20070406220827.GG8209@alvh.no-ip.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox