Re: Role Authentication Failure

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(at)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(dot)klaver(at)gmail(dot)com