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.
