"Mick McElarney" <Mick(dot)McElarney(at)maxsp(dot)com> writes:
> What should I change so that it reads my /home/postgres/.pgpass file
> when I execute a psql -Upostgres databasename?
When you're logged in as somebody besides postgres, you mean? It can't
do that, and it'd be a huge security hole if it could.
You can, however, have it read your *own* .pgpass file for an entry
giving the postgres password.
regards, tom lane