Unix Technical Forum

posgres can't login?

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 ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Novice

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 11:17 PM
Tom Allison
 
Posts: n/a
Default 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)?

---------------------------(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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:19 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com