Re: authentication failure

Try "psql -W" for prompting the password forcefully.

On Fri, Jan 3, 2014 at 2:46 PM, Jayadevan M <maymala.jayadevan@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.linkedin.com/in/asheshvashi