pg_pwd and pg_shadow - Mailing list pgsql-admin

From Anthony Metzidis
Subject pg_pwd and pg_shadow
Date
Msg-id 97k872$22ah$1@news.tht.net
Whole thread Raw
List 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



pgsql-admin by date:

Previous
From: Johan Segernas
Date:
Subject: RE: COPY doesn't works when containing ' ' or ' ' charact ers on db
Next
From: Silky Mittal
Date:
Subject: Unable to start PostgreSQL from user other than root