When the method is trust it allows one to connect to the db with any user name supplied. When you change the method to
md5the user name must exist in the database before connecting.
After you initially installed postgres did you connect to the db and issue a CREATE USER garfield command?
On Thu, Jan 20, 2005 at 04:10:17PM +0700, Akbar wrote:
> 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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings