Re: authentication failure - Mailing list pgsql-general
Hi,
On Fri, Jan 3, 2014 at 3:32 PM, Jayadevan M <maymala.jayadevan@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.
On Fri, Jan 3, 2014 at 2:49 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:Try "psql -W" for prompting the password forcefully.--On Fri, Jan 3, 2014 at 2:46 PM, Jayadevan M <maymala.jayadevan@gmail.com> wrote:JayadevanOther 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?Any clues? How do I trouble-shoot?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.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,
--Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
pgsql-general by date: