cannot connect using terminal nor pgaccess
| От | Jaume Teixi |
|---|---|
| Тема | cannot connect using terminal nor pgaccess |
| Дата | |
| Msg-id | 20010521161919.6dd07b95.teixi@6tems.com обсуждение |
| Ответы |
Re: cannot connect using terminal nor pgaccess
Re: cannot connect using terminal nor pgaccess Re: cannot connect using terminal nor pgaccess |
| Список | pgsql-admin |
$ 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 по дате отправления: