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: