Date: Mon, 29 Jan 2007 09:01:32 -0800 From: George Hartzell <hartzell@alerce.com> To: Bill Moran <wmoran@collaborativefusion.com> Cc: hartzell@alerce.com, freebsd-ports@freebsd.org Subject: Re: postgresql's 502.pgsql periodic script and passwords Message-ID: <17854.10348.710376.647552@satchel.alerce.com> In-Reply-To: <20070129092352.40c17abe.wmoran@collaborativefusion.com> References: <20070129092352.40c17abe.wmoran@collaborativefusion.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Bill Moran writes: > 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 It seems that .pgpass won't even be used if it's not chmoded 600. Thanks! g.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?17854.10348.710376.647552>