pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
alter user log entry, too much information ;)
2+ messages / 2 participants
[nested] [flat]

* alter user log entry, too much information ;)
@ 2007-04-06 19:35  Ray Stell <stellr@cns.vt.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: Ray Stell @ 2007-04-06 19:35 UTC (permalink / raw)
  To: pgsql-admin

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?  



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: alter user log entry, too much information ;)
@ 2007-04-06 22:08  Alvaro Herrera <alvherre@commandprompt.com>
  parent: Ray Stell <stellr@cns.vt.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Alvaro Herrera @ 2007-04-06 22:08 UTC (permalink / raw)
  To: Ray Stell <stellr@cns.vt.edu>; +Cc: 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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-04-06 22:08 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-06 19:35 alter user log entry, too much information ;) Ray Stell <stellr@cns.vt.edu>
2007-04-06 22:08 ` Alvaro Herrera <alvherre@commandprompt.com>

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