Thread: posgres can't login?

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)?

Tom Allison <tallison@tacocat.net> writes:
> 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"
> ... etc ...

> I get this at every startup but I can't find anything that does not work.

Perhaps this is the trace of pg_ctl probing to see whether the
postmaster's up yet?  Normally it should stop after one attempt
though, because it's programmed to interpret a "no password supplied"
failure as meaning the postmaster is up.  Perhaps you are launching
pg_ctl in an account that has a ~/.pg_pass file that is wrong?

            regards, tom lane