Re: alter user log entry, too much information ;)

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: alter user log entry, too much information ;)
Date: 2007-04-06 22:08:27
Message-ID: 20070406220827.GG8209@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Karthikeyan Sundaram 2007-04-07 17:33:19 rowcount function in postgres???
Previous Message Ray Stell 2007-04-06 19:35:59 alter user log entry, too much information ;)