postgresql's 502.pgsql periodic script and passwords

[Bill Moran]

In response to George Hartzell <hartzell at alerce.com>:
> 
> I'm curious how other freebsd postgresql users handle databases with
> passwords and running the 502.pgsql periodic script.
> 
> I've "solved" the problem by creating a ~pgsql/.pgpass file with the
> pgsql users password.
> 
> Is there a better way?

Depends.  Do you allow untrusted users to log in to that machine?  If
so, then you've probably got the best approach.  Make sure that .pgpass
file is chmoded 600

-- 
Bill Moran
Collaborative Fusion Inc.