postgresql's 502.pgsql periodic script and passwords

George Hartzell hartzell at
Mon Jan 29 16:59:22 UTC 2007

Bill Moran writes:
 > In response to George Hartzell <hartzell at>:
 > > 
 > > 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.



More information about the freebsd-ports mailing list