cannot connect using terminal nor pgaccess

From: Jaume Teixi <teixi(at)6tems(dot)com>
To: psql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: cannot connect using terminal nor pgaccess
Date: 2001-05-21 14:19:19
Message-ID: 20010521161919.6dd07b95.teixi@6tems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-05-21 14:37:40 Re: simpler query significantly slower
Previous Message twanger 2001-05-21 12:18:31 simpler query significantly slower