I just can't connect to a database, though I can to others as other users...
postgres=# CREATE ROLE xyz WITH password 'abc' ;
CREATE ROLE
postgres=# CREATE DATABASE LabNews_dev WITH OWNER=xyz ENCODING='UTF8' ;
CREATE DATABASE
postgres=# grant create, connect on database LabNews_dev to xyz with grant option;
GRANT
--------------------------------
In pg_hba.conf:
local LabNews_dev labnews trust
host LabNews_dev labnews ###.###.###.###/32 trust # crushinator (Taylor)
-------------------------------
In postgresql.conf:
listen_addresses = '*'
#ssl = true # (change requires restart)
#password_encryption = on
------------------------------
I've reloaded (& restarted) the DB
=======================================
WHAT DOESN'T WORK:
postgres@flexo:~/8.2/main$ psql -U xyz LabNews_dev
psql: FATAL: database "LabNews_dev" does not exist
okay...
postgres@flexo:~/8.2/main$ psql -U xyz labnews_dev
psql: FATAL: no pg_hba.conf entry for host "[local]", user "labnews", database "labnews_dev", SSL off
AND REMOTELY:
smithrn@smithrn-ltb1:~$ psql -h thathost -U xyz labnews_dev
Password for user labnews:
psql: FATAL: password authentication failed for user "labnews"
And I have ALTER ROLE'd to assure I set the password right.
=========================================
HOWEVER:
postgres@flexo:~/8.2/main$ psql -U otherdbuser otherdb
Welcome to psql 8.2.6, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
airburst=#
and
smithrn@smithrn-ltb1:~$ psql -h flexo -U otherdbuser otherdb
Welcome to psql 8.2.7 (server 8.2.6), the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
airburst=# \q
What am I missing???
Thanks!