From owner-freebsd-ports@FreeBSD.ORG  Mon Jan 29 16:59:22 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 B240D16A400
	for <freebsd-ports@freebsd.org>; Mon, 29 Jan 2007 16:59:22 +0000 (UTC)
	(envelope-from hartzell@alerce.com)
Received: from merlin.alerce.com (he94-x.tigertech.net [64.62.142.94])
	by mx1.freebsd.org (Postfix) with ESMTP id 96A6313C4A5
	for <freebsd-ports@freebsd.org>; Mon, 29 Jan 2007 16:59:22 +0000 (UTC)
	(envelope-from hartzell@alerce.com)
Received: from merlin.alerce.com (localhost [127.0.0.1])
	by merlin.alerce.com (Postfix) with ESMTP id EF4A333C5D;
	Mon, 29 Jan 2007 08:59:28 -0800 (PST)
Received: from satchel.alerce.com (w092.z064001164.sjc-ca.dsl.cnc.net
	[64.1.164.92])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(Client CN "satchel.alerce.com", Issuer "alerce.com" (verified OK))
	by merlin.alerce.com (Postfix) with ESMTP id B284133C5B;
	Mon, 29 Jan 2007 08:59:28 -0800 (PST)
Received: from satchel.alerce.com (localhost [127.0.0.1])
	by satchel.alerce.com (8.13.8/8.13.8) with ESMTP id l0TH1Yi3046023
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK);
	Mon, 29 Jan 2007 09:01:34 -0800 (PST)
	(envelope-from hartzell@satchel.alerce.com)
Received: (from hartzell@localhost)
	by satchel.alerce.com (8.13.8/8.13.8/Submit) id l0TH1XqF046016;
	Mon, 29 Jan 2007 09:01:33 -0800 (PST) (envelope-from hartzell)
From: George Hartzell <hartzell@alerce.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <17854.10348.710376.647552@satchel.alerce.com>
Date: Mon, 29 Jan 2007 09:01:32 -0800
To: Bill Moran <wmoran@collaborativefusion.com>
In-Reply-To: <20070129092352.40c17abe.wmoran@collaborativefusion.com>
References: <20070129092352.40c17abe.wmoran@collaborativefusion.com>
X-Mailer: VM 7.19 under 21.4 (patch 20) "Double Solitaire" XEmacs Lucid
X-Virus-Scanned: ClamAV using ClamSMTP
Cc: hartzell@alerce.com, 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
Reply-To: hartzell@alerce.com
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 16:59:22 -0000

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.