| 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: | Whole Thread | Raw Message | 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 |