Re: authentication failure

I am able to login from the non-chroot environment. So it is not an issue
with pg_hba.conf and not an issue of password expiration. Is there a debug
psql option?

On Fri, Jan 3, 2014 at 5:09 PM, Chris Curvey <chris(at)chriscurvey(dot)com> wrote:

>
>
>
> On Fri, Jan 3, 2014 at 4:16 AM, Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>wrote:
>
>> Hi,
>> I am trying to login from psql and consistently getting a
>> "psql: FATAL: password authentication failed for user "xyz"" for all
>> users. I am not being prompted for a password at all. I faced a similar
>> issue sometime ago because there was a .pgpass file and it had wrong
>> entries. This time there is no .pgpass file.
>> Any clues? How do I trouble-shoot?
>> Other possibly relevant info - this is a chrooted environment. I upgraded
>> the OS recently in this env and faced some issues with /dev/null /proc etc
>> not being present and so on. Some issues there?
>> The database itself is running in the same server in the non-chroot
>> environment. I am also running a python application which uses psycopg2 and
>> that is working fine.
>> Regards,
>> Jayadevan
>>
>
> Could it be a problem with your pg_hba.conf? Perhaps password
> authentication is not enabled there?
>
>
>
> --
> I asked the Internet how to train my cat, and the Internet told me to get
> a dog.
>