PG_PWD and PG_SHADOW

From: "Anthony Metzidis" <metzidis(at)mednet(dot)ucla(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: PG_PWD and PG_SHADOW
Date: 2001-03-01 01:39:59
Message-ID: 97k91f$22f8$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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-general by date

  From Date Subject
Next Message Tom Lane 2001-03-01 01:55:59 Re: how to vacuum from cron?
Previous Message Francisco Reyes 2001-03-01 01:05:50 Re: Slowdown problem when writing 1.7million records