PG_PWD and PG_SHADOW - Mailing list pgsql-general

From Anthony Metzidis
Subject PG_PWD and PG_SHADOW
Date
Msg-id 97k91f$22f8$1@news.tht.net
Whole thread Raw
List 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



pgsql-general by date:

Previous
From: "Jonny Deng"
Date:
Subject: Want to learn the Postgresql database system
Next
From: "Oberpriller, Wade D."
Date:
Subject: PLPGSQL