Re: password authentication failed for .. - Mailing list pgsql-general

From Doug McNaught
Subject Re: password authentication failed for ..
Date
Msg-id 87brqam9rr.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to password authentication failed for ..  ("Manu M P" <manu.mp@maildrop.m2comsys.com>)
Responses Re: password authentication failed for ..
List pgsql-general
"Manu M P" <manu.mp@maildrop.m2comsys.com> writes:

> Hi
>
> I have the data base "test" and two users "test1" "test2". I added the following record to pg_hba.conf
>
> local test password passwords
>
> I then created the "passwords" file in $PGDATA using pg_pasword and
> added entries for the two users "test1" and "test2".

Ummm...

Passwords are stored in the 'pg_shadow' table and set using
CREATE/ALTER USER, not in a file.

I've never heard of a 'pg_password' program and it is not part of the
standard distribution.

-Doug

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: PostgreSQL on Windows Server 2003
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL on Windows Server 2003