Re: password authentication failed for ..

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: <manu(dot)mp(at)maildrop(dot)m2comsys(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: password authentication failed for ..
Date: 2003-12-15 14:32:40
Message-ID: 87brqam9rr.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Manu M P" <manu(dot)mp(at)maildrop(dot)m2comsys(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-12-15 14:41:37 Re: PostgreSQL on Windows Server 2003
Previous Message Johnson, Shaunn 2003-12-15 14:31:47 PostgreSQL on Windows Server 2003