Postgres Pro
Downloads
Home   >   mailing lists

Re: alter user log entry, too much information ;) - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: alter user log entry, too much information ;)
Date
Msg-id 20070406220827.GG8209@alvh.no-ip.org
Whole thread Raw
In response to alter user log entry, too much information ;)  (Ray Stell <stellr@cns.vt.edu>)
List pgsql-admin
Tree view 
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.

pgsql-admin by date:

Previous
From: Ray Stell
Date:
Subject: alter user log entry, too much information ;)
Next
From: Karthikeyan Sundaram
Date:
Subject: rowcount function in postgres???