Problem installing Stash 3.7 to use PostgreSQL

Question

I am following the instructions on https://confluence.atlassian.com/display/STASH/Connecting+Stash+to+PostgreSQL

But after running the two "CREATE" commands in psql, the user still does not seem to be valid.  During install the test connection to the database fails and I also can't connect from the command line like this:

-bash-4.2$ psql -h localhost -d stash -U stashuser -W
Password for user stashuser: 
psql: FATAL: Ident authentication failed for user "stashuser"
-bash-4.2$

My CREATE commands were

CREATE ROLE stashuser WITH LOGIN PASSWORD 'JELLYFISH' VALID UNTIL 'infinity';

CREATE DATABASE stash WITH ENCODING='UTF8' OWNER=stashuser CONNECTION LIMIT=-1;

I am new to PostgreSQL so could there be more I need to do there?  Like flush privileges or something?

This is a new server I am setting up, with hardware more like what we wish to deploy.

Thanks

Mark

IT BS · Answer

What were your remved config lines ?

Thanks

Mark Ruedy · Answer

I found there where other config lines in pg_hba.conf causing the problem.  I've eliminated them, restarted postgresql.  Now it works fine.  Sorry about that.

Mark Ruedy · Answer

I updated the pg_hba.conf to what you have (left off IPv6 part) but still get the same message.  Is that postgresql user supposed to match some OS user/pass or is it confined to postgresql?

[root@gitpc data]# psql -h 127.0.0.1 -d stash -U stashuser -W
Password for user stashuser: 
psql: FATAL: Ident authentication failed for user "stashuser"
[root@gitpc data]#

Is there any debugging facility for postgresql authentication?