[ADMIN] Authentication Problems

[Epps, Aaron M.]

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...

[EMAIL PROTECTED] 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)?

 

[EMAIL PROTECTED] aaron]$ psql test -U testing -W
Password:
psql: FATAL:  IDENT authentication failed for user "testing"

 

[EMAIL PROTECTED] aaron]$