From: | Emmanuel Dreyfus <manu(at)netbsd(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | password method in pg_hba.conf fails |
Date: | 2003-02-26 16:44:54 |
Message-ID: | 20030226164454.GE12956@melancolie.net.espci.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello everybody
I just upgraded from 7.2.2 to 7.3.2, and I this upgrade broke the way I
handled authentication.
I had an external password file ~pgsql/data/pg_passwd with lines like this:
guest:OgP29.PYhgA
~pg_hba.conf/data/ contains entries like this (I had to add one field when
upgrading to 7.3.2, the beast complaining about it)
local all guest trust
local template1 all password pg_passwd
local dirdb all password pg_passwd
Then I try to login. I get this:
$ psql -U pgsql dirdb
Password:
psql: FATAL: Password authentication failed for user "pgsql"
ktrace'ing the postgres process (I'm running on NetBSD) shows that it never
try to open ~pgsql/data/pg_passwd.
What turned wrong?
--
Emmanuel Dreyfus
manu(at)netbsd(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Tkach | 2003-02-26 16:48:09 | Re: Compilation errors? |
Previous Message | Robert Fitzpatrick | 2003-02-26 16:26:59 | Automated backup |