postgresql's 502.pgsql periodic script and passwords
George Hartzell
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.
Thanks!
g.
More information about the freebsd-ports
mailing list