> > > > > > # "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?
