[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

postgresql and plain passwd.



Dear Users and Developers,

today I tried to setup the passwd authentication of postgresql and failed
miserably.

I edited /etc/pg_hba.conf and added this line:
(note: not copied from the file)

host tablename 137.x.x.x 0.0.0.0 password passwd

I then add a new user as DBA using "createuser" (say joe).  Using
"pg_passwd passwd"  in the database directory ( in this case
/var/postgres/data ) I add an entry for this user to the password file. 

If I now try to connect to the database from the other computer
(137.x.x.x) by "psql -h server database", joe gets connected to the
database, but he is not asked for a password. The passwd file is ignored
completely (i.e. it doesn't matter wether it exists, nor what it's
contents are). It doesn't matter, if joe passes "-u" to psql nor which
password he supplies, either.

What am I missing here?
Any additional man pages / FAQs to be read? 

Thanks in advance,

Jens

P.S.: Please keep the CC list, thanks.


Reply to: