[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 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?

> --
> Boyd Stephen Smith Jr.                     ,= ,-_-. =.
> bss03@volumehost.net                      ((_/)o o(\_))
> ICQ: 514984 YM/AIM: DaTwinkDaddy           `-'(. .)`-'
> http://iguanasuicide.org/                      \_/

Reply to: