Hi everyone, I have a postgresql 6.5.3 installed on a redhat machine (base 6.0 but the rpms are from 6.1). Until now everything works fine with it (even www+php access). Last night I encountered this problem. I want to be able to connect to the database server using "password" as the authentification method and a separate file with the passwords. First I logged in with the postgres user and created this 3 accounts: "acc1" "acc2" "acc3". After that I created a database named "access" (with the postgres user) and some tables (also with the same user). I granted some access to this tables to "acc1", "acc2", "acc3". I modified "pg_hba.conf" to allow to users to connect to this database: host access 192.168.0.1 255.255.255.255 password passwd host all 127.0.0.1 255.255.255.255 password passwd The server is started with -i option, also my PG_DATA dir is /var/lib/pgsql . There I have the passwd file created with pg_passwd. The problem is that now I cannot connect even with the postgres user (using psql -u -h 127.0.0.1 access). Before the changes in hba file I used a trust configuration (default for redhat). This is the error I get with psql: Connection to database 'access' failed. Password authentification failed for user 'postgres' Now I have tried even with very easy password 'aaa'-like and it doesnt work. A very strange thing what I have observed is that the pg_passwd command generates different encrypted passwords for the same password each time I use it. Example of output for pg_passwd user postgres password 'aaa': postgres:zy9FDU9OGyOY. or postgres:mCROIgwpOLhB. What is happening ? Thanks ------------------------------ Dizzy == Linux textmode console maniac
