postgresql's 502.pgsql periodic script and passwords
wmoran at collaborativefusion.com
Mon Jan 29 14:23:54 UTC 2007
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
Collaborative Fusion Inc.
More information about the freebsd-ports