postgresql's 502.pgsql periodic script and passwords
hartzell at alerce.com
Mon Jan 29 16:59:22 UTC 2007
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.
More information about the freebsd-ports