Re: simple md5 authentication problems
От | kmh496 |
---|---|
Тема | Re: simple md5 authentication problems |
Дата | |
Msg-id | 1147097431.29626.16.camel@var.sirfsup.com обсуждение исходный текст |
Ответ на | simple md5 authentication problems ("robert" <robertlazarski@gmail.com>) |
Ответы |
Re: simple md5 authentication problems
|
Список | pgsql-general |
> > > > > > # "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?
В списке pgsql-general по дате отправления: