password authentication always failed - Mailing list pgsql-novice

From Akbar
Subject password authentication always failed
Date
Msg-id 1106212217.10828.3.camel@tux.akbarhome
Whole thread Raw
Responses Re: password authentication always failed
List pgsql-novice
Hi,
I have superuser named postgres and normal user named garfield.
Then I do this in command prompt :
$ su postgres
$ initdb -D /usr/local/pgsql/proj -U garfield
$ psql -U garfield -f mydb.sql template1
$ psql -U garfield mydb

Ok, everything is fine.... I can connect to database and do some
operation.
Note: mydb.sql was created with this command before:
$ pg_dump -u -C -f mydb.sql mydb

Then I changed the pg_hba.conf in /usr/local/pgsql/proj from :
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
# IPv6 local connections:
host    all         all         ::1/128               trust

to
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               md5
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
# IPv6 local connections:
host    all         all         ::1/128               trust

Then I restarted database. When I do this command:
$ psql -U garfield mydb
password:
It always failed with error:
FATAL:  password authentication failed for user "garfield"
psql: FATAL:  password authentication failed for user "garfield"

I have done this as postgres to make sure that password is correct:
# ALTER USER garfield PASSWORD 'garfield' CREATEDB;

What is wrong? garfield can create database but not another user.
Could that be problem?????

Thank you.

Regards,

Akbar




pgsql-novice by date:

Previous
From: "Keith Worthington"
Date:
Subject: log file
Next
From: Michael Fuhr
Date:
Subject: Re: log file