Postgres Pro
Downloads
Home   >   mailing lists

psql: FATAL: role "xyz" is not permitted to log in - Mailing list pgsql-general

From Ralph Smith
Subject psql: FATAL: role "xyz" is not permitted to log in
Date
Msg-id 2BDD129E-D0E4-4DEE-BDA3-18411ECA8EC8@washington.edu
Whole thread Raw
Responses Re: psql: FATAL: role "xyz" is not permitted to log in
List pgsql-general
Tree view
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!


Ralph
=====================



pgsql-general by date:

Previous
From: Andreas 'ads' Scherbaum
Date:
Subject: Re: creating a temp table in a function
Next
From: Tom Lane
Date:
Subject: Re: psql: FATAL: role "xyz" is not permitted to log in