password authentication always failed
От | Akbar |
---|---|
Тема | password authentication always failed |
Дата | |
Msg-id | 1106212217.10828.3.camel@tux.akbarhome обсуждение исходный текст |
Ответы |
Re: password authentication always failed
|
Список | 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 по дате отправления: