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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general