pg_pwd and pg_shadow

From: "Anthony Metzidis" <metzidis(at)mednet(dot)ucla(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_pwd and pg_shadow
Date: 2001-03-01 01:25:54
Message-ID: 97k872$22ah$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
When I 'CREATE USER testuser WITH PASSWORD 'mypassword';
I see an entry in PG_PWD with the password 'mypassword' in plaintext.

In my pg_hba.conf I have all hosts using 'password' authentication with no
file argument. Is there any way to keep postgres from saving the passwords
in PG_PWD? I thought that passwords were to be saved in PG_SHADOW. What is
PG_SHADOW for anyway?

If you have an answer, can you please send it to me via email?

Thanks.

--tony

Browse pgsql-admin by date

  From Date Subject
Next Message Grant 2001-03-01 01:26:59 Vacuum.
Previous Message Derek Neighbors 2001-02-28 23:05:52 Re: Python, Postgres support?