[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: where is postgresql-8.3's packager's instructions?

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
># "local" is for Unix domain socket connections only
>local   all         all                               ident sameuser
># IPv4 local connections:
>host    all         all          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.

Reply to: