Re: How to mask password when using ALTER USER syntax in psql.

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Kenneth Banyas <kenneth(dot)banyas-1(at)nasa(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to mask password when using ALTER USER syntax in psql.
Date: 2009-09-10 22:28:48
Message-ID: 20090910222848.GF31165@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Kenneth Banyas wrote:
> Greetings,
>
> I am using versions 7.4 and 8.3.7.
> I have not discovered a way to obfuscate the password when changing it
> in psql with ALTER USER syntax.
> The password displays in clear text at the command line AND in the log file.
> Why is this?

Perhaps you could try \password in psql.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Kempter 2009-09-11 03:59:22 sql to show tablespace for indexes
Previous Message Tom Lane 2009-09-10 19:03:28 Re: How to mask password when using ALTER USER syntax in psql.