postgres access - pg_hba.conf

Поиск
Список
Период
Сортировка
От bruce
Тема postgres access - pg_hba.conf
Дата
Msg-id 03d001c79e0c$24634470$0301a8c0@tmesa.com
обсуждение исходный текст
Ответы Re: postgres access - pg_hba.conf  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-general
Hi..

I'm trying to setup an app (gforge) to communicate using the postgres db.

I've modified the pg_hba.conf file and I can sort of get access. However, it
appears that I can't access the database using a passwd. I assume I'm using
the wrong passwd, although I created the db, and thought that this was the
passwd for the db! Is there a way to change the passwd? I have root access
to the system, but I'm not a postgres dba...

I have the following pg_hba.conf file:
 # GFORGE5
 #local all all trust
 local all all md5
 # IPv4 local connections:
 host    all         all         127.0.0.1    255.255.255.255  md5
 #host    all         all         127.0.0.1    255.255.255.255  trust


I type the following:
  [root@lserver2 ~]# psql -d gforge -U gforge -h 127.0.0.1 -W gforge
  psql: warning: extra command-line argument "gforge" ignored
  Password for user gforge:

I get:
  psql: FATAL:  password authentication failed for user "gforge"


Any thoughts/etc...
Basically, it looks like I need to know how to create a database, with a
user/dbname/db address/passwd so the pg_hba.conf works correctly...

(If i leave out the md5, and use the "trust" then I can access the db
without a passwd, but that's not what I need.)

thanks

-bruce
bedouglas@earthlink.net


В списке pgsql-general по дате отправления:

Предыдущее
От: cjl
Дата:
Сообщение: Rookie Questions: Storing the results of calculations vs. not?
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: SQL Manager 2007 for PostgreSQL released