PG_PWD and PG_SHADOW

Started by Anthony Metzidisabout 25 years ago1 messagesgeneral
Jump to latest
#1Anthony Metzidis
metzidis@mednet.ucla.edu

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