| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, dinesh kumar <dineshkumar02(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: authentication failure |
| Date: | 2014-01-05 20:47:02 |
| Message-ID: | 52C9C4C6.8020809@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Konoplev | 2014-01-05 22:08:39 | Re: help interpreting pg_stat_user_index view values |
| Previous Message | Tom Lane | 2014-01-05 17:48:19 | Re: authentication failure |