Search Postgresql Archives

Re: Role Authentication Failure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 04/15/2013 07:29 PM, Carlos Mennens wrote:
I dropped both roles (Carlos & DBA) from the database and I will show
you exactly what I'm doing:


Now I login as 'carlos':

carlos@debian:~$ psql -d postgres
Password:
psql (9.1.9)
Type "help" for help.

postgres=>

but...

To add to my post from last night:

1) What is in your pg_hba.conf file?

2) When you do psql -d postgres are you sure you are logging in as carlos? In other words no PGUSER set. While debugging this I would try to be as explicit as possible in your command line

3) Do you have a .pgpass file and does its contents match the users/passwords you are using?


--
Carlos Mennens




--
Adrian Klaver
adrian.klaver@xxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux