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"
Just noticed while testing here:
aklaver@panda:~> psql -d test -U aklaver -h localhost
psql: FATAL: password authentication failed for user "aklaver"
password retrieved from file "/home/aklaver/.pgpass"
So psql tells you when you are getting password from pgpass.
>
> But...
>
> find / -name .pgpass
> <no file found>
>
> $ env | grep PG
> PGPORT=1234
> PGUSER=postgres
> PGHOST=localhost
Hmm, I am going to have to think about this.
>
>
>
>
--
Adrian Klaver
adrian.klaver@gmail.com