From owner-freebsd-ports@FreeBSD.ORG  Mon Jan 29 14:23:54 2007
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
X-Original-To: freebsd-ports@freebsd.org
Delivered-To: freebsd-ports@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 3102216A400
	for <freebsd-ports@freebsd.org>; Mon, 29 Jan 2007 14:23:54 +0000 (UTC)
	(envelope-from wmoran@collaborativefusion.com)
Received: from mx00.pub.collaborativefusion.com
	(mx00.pub.collaborativefusion.com [206.210.89.199])
	by mx1.freebsd.org (Postfix) with ESMTP id D3C8F13C4A8
	for <freebsd-ports@freebsd.org>; Mon, 29 Jan 2007 14:23:53 +0000 (UTC)
	(envelope-from wmoran@collaborativefusion.com)
Received: from vanquish.pgh.priv.collaborativefusion.com
	(vanquish.pgh.priv.collaborativefusion.com [192.168.2.61])
	(SSL: TLSv1/SSLv3,256bits,AES256-SHA)
	by wingspan with esmtp; Mon, 29 Jan 2007 09:23:53 -0500
	id 00056412.45BE0379.00004CC5
Date: Mon, 29 Jan 2007 09:23:52 -0500
From: Bill Moran <wmoran@collaborativefusion.com>
To: hartzell@alerce.com
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>
Organization: Collaborative Fusion
X-Mailer: Sylpheed 2.3.0 (GTK+ 2.10.7; i386-portbld-freebsd6.1)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Cc: freebsd-ports@freebsd.org
Subject: Re: postgresql's 502.pgsql periodic script and passwords
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 29 Jan 2007 14:23:54 -0000

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.