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 по дате отправления: