Re: where is postgresql-8.3's packager's instructions?
On Sun, Dec 7, 2008 at 9:32 AM, 中和刘 <minxinjianxin@gmail.com> wrote:
> On Sun, Dec 7, 2008 at 5:34 AM, Boyd Stephen Smith Jr.
> <bss03@volumehost.net> wrote:
>> 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.
> 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. ,= ,-_-. =.
>> bss03@volumehost.net ((_/)o o(\_))
>> ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-'
>> http://iguanasuicide.org/ \_/
>>
>
Reply to: