Thread: alter user log entry, too much information ;)
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?
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.