Re: how _not_ to log?

From: Ray Stell <stellr(at)vt(dot)edu>
To: Tim Spencer <tspencer(at)cloudpassage(dot)com>
Cc: Joe Van Dyk <joe(at)tanga(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: how _not_ to log?
Date: 2013-07-26 18:13:39
Message-ID: 5D500121-9F17-49A0-9C1B-0BAF32DD754B@vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jul 26, 2013, at 1:42 PM, Tim Spencer wrote:
> On Jul 25, 2013, at 11:45 PM, Joe Van Dyk <joe(at)tanga(dot)com> wrote:
>> Have chef supply the password in encrypted format.
>>
> I was hoping that somebody would be able to solve my logging issue instead of me having to rejigger my nice centralized password system.

Another "rejigger" idea would be to use psql meta-command:
\password fred
It logs a little more friendly:
2013-07-26 13:59:58 EDT,0,idle LOG: 00000: statement: ALTER USER fred PASSWORD 'md5af0d89ddc522353ffe41de823a94c0e1'
http://www.postgresql.org/docs/9.2/interactive/app-psql.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2013-07-26 18:27:42 Re: how _not_ to log?
Previous Message Tim Spencer 2013-07-26 17:42:58 Re: how _not_ to log?