postgresql's 502.pgsql periodic script and passwords

[George Hartzell]

Bill Moran writes:
 > 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

It seems that .pgpass won't even be used if it's not chmoded 600.

Thanks!

g.