This is a discussion on posgres can't login? within the pgsql Novice forums, part of the PostgreSQL category; --> 2006-11-11 08:27:10 EST 6158 [unknown] LOG: connection received: host=[local] 2006-11-11 08:27:10 EST 6158 postgres FATAL: password authentication failed for ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 2006-11-11 08:27:10 EST 6158 [unknown] LOG: connection received: host=[local] 2006-11-11 08:27:10 EST 6158 postgres FATAL: password authentication failed for user "postgres" 2006-11-11 08:27:11 EST 6161 [unknown] LOG: connection received: host=[local] 2006-11-11 08:27:11 EST 6161 postgres FATAL: password authentication failed for user "postgres" 2006-11-11 08:27:11 EST 6164 [unknown] LOG: connection received: host=[local] 2006-11-11 08:27:11 EST 6164 postgres FATAL: password authentication failed for user "postgres" 2006-11-11 08:27:12 EST 6167 [unknown] LOG: connection received: host=[local] 2006-11-11 08:27:12 EST 6167 postgres FATAL: password authentication failed for user "postgres" 2006-11-11 08:27:12 EST 6168 [unknown] LOG: connection received: host=[local] I get this at every startup but I can't find anything that does not work. I did change the postgresql.conf file for authentication of local postgres access from 'sameuser ident' to 'md5'. Is this something I can effectively ignore? (If so, why FATAL?) or is there something I can do to fix it (without going to sameuser ident)? ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |