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

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
>>># "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.
> 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: