Here's my config file...
pg_hba.conf
local all all trust
PostgreSQL Users...
test=# \du
List of database users
User name | User ID | Attributes
-----------+---------+----------------------------
aaron | 100 | superuser, create database
postgres | 1 | superuser, create database
testing | 101 |
Databases...
[aaron(at)r0070671 aaron]$ psql -l
List of databases
Name | Owner | Encoding
---------------+----------+-----------
aaron | aaron | SQL_ASCII
issue-tracker | aaron | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
test | aaron | SQL_ASCII
(5 rows)
why when I run the following command does authentication fail (Yes, password is correct)?
[aaron(at)r0070671 aaron]$ psql test -U testing -W
Password:
psql: FATAL: IDENT authentication failed for user "testing"
[aaron(at)r0070671 aaron]$