cannot connect using terminal nor pgaccess

Поиск
Список
Период
Сортировка
$ psql -d template1 -U postgres
psql: Peer authentication failed for user 'postgres'


$ psql -d template1 -U postgres -h localhost -p 5432
psql: IDENT authentication failed for user 'postgres'

$ grep -v ^# /etc/postgresql/pg_hba.conf | grep -i sameuser
local        all                                           peer sameuser
host         all         127.0.0.1     255.255.255.0       ident sameuser

$ su - postgres -- psql template1
Password:
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

template1=# select postgres from pg_user;
   usename   | usesysid | usecreatedb | usetrace | usesuper | usecatupd |
passwd  | valuntil
-------------+----------+-------------+----------+----------+-----------+----------+----------
 postgres    |       31 | t           | t        | t        | t         |
******** |


what I am missing in this case ?

thanks!

--
Jaume Teixi
    CTO
    6TEMS - Ducform, SA
    http://www.6tems.com


В списке pgsql-admin по дате отправления:

Предыдущее
От: twanger@smartvia.de
Дата:
Сообщение: simpler query significantly slower
Следующее
От: Tom Lane
Дата:
Сообщение: Re: simpler query significantly slower