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 <ch...@chriscurvey.com> wrote: > > > > On Fri, Jan 3, 2014 at 4:16 AM, Jayadevan M > <maymala.jayade...@gmail.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. >