Re: authentication failure - Mailing list pgsql-general

From Adrian Klaver
Subject Re: authentication failure
Date
Msg-id 52C9C4C6.8020809@gmail.com
Whole thread Raw
In response to Re: authentication failure  (Jayadevan M <maymala.jayadevan@gmail.com>)
List pgsql-general
On 01/05/2014 07:47 AM, Jayadevan M wrote:
> With md5
> psql
> psql: FATAL:  password authentication failed for user "postgres"
>
> with trust
> psql -h localhost
> psql (9.3.2)
> Type "help" for help.
>
> back to md5
> psql -h localhost
> psql: FATAL:  password authentication failed for user "postgres"
>
> But...
>
> find / -name .pgpass
> <no file found>
>
> $ env | grep PG
> PGPORT=1234
> PGUSER=postgres
> PGHOST=localhost
>
>

So the env is from the root account in the chroot?

Is it the same as the postgres account?

The only suggestion I have left is to look at the chroot setup.

See Toms post for another suggestion.


--
Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: authentication failure
Next
From: Sergey Konoplev
Date:
Subject: Re: help interpreting pg_stat_user_index view values