postgresql's 502.pgsql periodic script and passwords

Bill Moran wmoran at
Mon Jan 29 14:23:54 UTC 2007

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

Bill Moran
Collaborative Fusion Inc.

More information about the freebsd-ports mailing list