Re: Role Authentication Failure - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Role Authentication Failure
Date
Msg-id 516D564A.9020502@gmail.com
Whole thread Raw
In response to Re: Role Authentication Failure  (Carlos Mennens <carlos.mennens@gmail.com>)
List pgsql-general
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@gmail.com


pgsql-general by date:

Previous
From: Eduardo Morras
Date:
Subject: Re: Backup advice
Next
From: Philipp Kraus
Date:
Subject: dataset lock