On Fri, Jan 3, 2014 at 5:13 PM, Jayadevan M <maymala.jayade...@gmail.com>wrote:
> 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? > > OK. Have you checked the PGPASSWORD environment variable, from where you are trying to login. Regards, Dinesh manojadinesh.blogspot.com > > > 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. >> > >
