On Sun, Dec 7, 2008 at 9:32 AM, 中和刘 <[EMAIL PROTECTED]> wrote: > On Sun, Dec 7, 2008 at 5:34 AM, Boyd Stephen Smith Jr. > <[EMAIL PROTECTED]> wrote: >> On Saturday 06 December 2008, "中和刘" <[EMAIL PROTECTED]> 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. > how can i make this configuration? i >> 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. > thank you, i prefer this one, but there are some questions: > i saw one method is: > template1=# ALTER USER postgres WITH PASSWORD 'password'; > another is > postgres=# ALTER ROLE postgres WITH PASSWORD 'password'; > and the document says, the default postgres and template1 databases > are not necessory for postgresql server, > then i'm owndering, how to set the password of the database user postgres? > where are the database users and their passwords stored in postgresql > server? not in the postgresql database? > thanks > after reading the document, i have know that we should use the alter role one, and a role is global for all the databases.
thank you all :) > >> -- >> Boyd Stephen Smith Jr. ,= ,-_-. =. >> [EMAIL PROTECTED] ((_/)o o(\_)) >> ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-' >> http://iguanasuicide.org/ \_/ >> >
