On Saturday 06 December 2008, "中和刘" <minxinjianxin@gmail.com> wrote about 'Re: where is postgresql-8.3's packager's instructions?': >when i connect to it using >pgadmin3(from the local >machine), i got the error: >-------------- >An error has occurred: >Error connecting to the server: FATAL: password authentication failed >for user "postgres" >---------------- >how can i fix it so that i can get pgadmin work? thanks > >here is my pg_hda.conf >------------------------ ># Database administrative login by UNIX sockets >local all postgres ident sameuser > ># TYPE DATABASE USER CIDR-ADDRESS METHOD > ># "local" is for Unix domain socket connections only >local all all ident sameuser ># IPv4 local connections: >host all all 127.0.0.1/32 md5 ># IPv6 local connections: >host all all ::1/128 md5 >----------------------- Looks like pgadmin3 is trying to conenct via tcp sockets. Over tcp, your pg_hda.conf requires a password. You have a couple of options: 1) Configure pgadmin3 to use unix sockets. In your pg_hda.conf, connections over unix sockets are automatically authenticated using the username associated with the process that is connecting. 2) Configure pgadmin3 to provide a password. If you haven't set a password yet, you can set one by using the psql tool as the user "postgres". You can use sudo or su to execute as a different user. -- Boyd Stephen Smith Jr. ,= ,-_-. =. bss03@volumehost.net ((_/)o o(\_)) ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-' http://iguanasuicide.org/ \_/
Attachment:
signature.asc
Description: This is a digitally signed message part.