Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 29 Jan 2007 09:23:52 -0500
From:      Bill Moran <wmoran@collaborativefusion.com>
To:        hartzell@alerce.com
Cc:        freebsd-ports@freebsd.org
Subject:   Re: postgresql's 502.pgsql periodic script and passwords
Message-ID:  <20070129092352.40c17abe.wmoran@collaborativefusion.com>
In-Reply-To: <17853.34664.178712.123312@satchel.alerce.com>
References:  <17853.34664.178712.123312@satchel.alerce.com>

next in thread | previous in thread | raw e-mail | index | archive | help
In response to George Hartzell <hartzell@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

-- 
Bill Moran
Collaborative Fusion Inc.



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20070129092352.40c17abe.wmoran>