Re: where is postgresql-8.3's packager's instructions?
On Sun, Dec 7, 2008 at 9:32 AM, 中和刘 <firstname.lastname@example.org> wrote:
> On Sun, Dec 7, 2008 at 5:34 AM, Boyd Stephen Smith Jr.
> <email@example.com> wrote:
>> On Saturday 06 December 2008, "中和刘" <firstname.lastname@example.org> 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?
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@example.com ((_/)o o(\_))
>> ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-'
>> http://iguanasuicide.org/ \_/