$ 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
