Re: simple md5 authentication problems

> > >
> > > # "local" is for Unix domain socket connections only
> > > local   all         all                               ident sameuser
> > > # IPv4 local connections:
> > > host    all         all         127.0.0.1/32          md5
> > > # IPv6 local connections:
> > > host    all         all         ::1/128               ident sameuser
> > >
> > > I created my db as:
> > > postgres=# CREATE DATABASE maragato_test OWNER postgres;
> > >
> > > I seem to have a user 'postgres' - I'm using the default.
> > >
> > > postgres=# SELECT * FROM "pg_user";
> > >  usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  |
> > > valuntil | useconfig
> > > ----------+----------+-------------+----------+-----------+----------+----------+-----------
> > >  postgres |       10 | t           | t        | t         | ******** |
> > >         |
> > >
> > > However, I get this error:
> > >
> > > /home/postgres> psql -h localhost maragato_test postgres
> > > Password for user postgres:
> > > psql: FATAL:  autenticação do tipo password falhou para usuário
> > > "postgres"
> > >
doesn't that user have to exist since you are using ident method?  that
means unix username == postgres username.
do you have a user named maragato_test on the system?
did you create that user in postgres and on the system?