From: | "bruce" <bedouglas(at)earthlink(dot)net> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | postgres access - pg_hba.conf |
Date: | 2007-05-24 14:02:15 |
Message-ID: | 03d001c79e0c$24634470$0301a8c0@tmesa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)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(at)earthlink(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2007-05-24 14:25:35 | Re: composite type array and index |
Previous Message | Célestin HELLEU | 2007-05-24 13:59:15 | Very big transaction in a stored procedure : how can i commit in the middle of it ? |