postgres access - pg_hba.conf
От | bruce |
---|---|
Тема | postgres access - pg_hba.conf |
Дата | |
Msg-id | 03d001c79e0c$24634470$0301a8c0@tmesa.com обсуждение исходный текст |
Ответы |
Re: postgres access - pg_hba.conf
|
Список | 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 по дате отправления: