Hi, On Fri, Jan 3, 2014 at 3:32 PM, Jayadevan M <maymala.jayade...@gmail.com>wrote:
> Nope - > psql -W > psql: FATAL: password authentication failed for user "postgres" > > There might be possible of the user's password expiration. Make the user's local authentication as trust, and reload the postgres instance, and check the "pg_user" table for the password expire date. If the password is expired, alter the user's expiration time. Regards, Dinesh manojadinesh.blogspot.com > > On Fri, Jan 3, 2014 at 2:49 PM, Ashesh Vashi < > ashesh.va...@enterprisedb.com> wrote: > >> Try "psql -W" for prompting the password forcefully. >> >> >> On Fri, Jan 3, 2014 at 2:46 PM, 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 >>> >>> >> >> >> -- >> -- >> >> Thanks & Regards, >> >> Ashesh Vashi >> EnterpriseDB INDIA: Enterprise PostgreSQL >> Company<http://www.enterprisedb.com> >> >> >> >> *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi> >> > >
