From owner-freebsd-ports@FreeBSD.ORG  Mon Jan 29 05:56:24 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 48B7016A400
	for <freebsd-ports@freebsd.org>; Mon, 29 Jan 2007 05:56:24 +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 3162A13C48E
	for <freebsd-ports@freebsd.org>; Mon, 29 Jan 2007 05:56:24 +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 E963D33C5D
	for <freebsd-ports@freebsd.org>; Sun, 28 Jan 2007 21:32:26 -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 9F8F733C5B
	for <freebsd-ports@freebsd.org>; Sun, 28 Jan 2007 21:32:26 -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 l0T5YW4K023488
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK)
	for <freebsd-ports@freebsd.org>; Sun, 28 Jan 2007 21:34:32 -0800 (PST)
	(envelope-from hartzell@satchel.alerce.com)
Received: (from hartzell@localhost)
	by satchel.alerce.com (8.13.8/8.13.8/Submit) id l0T5YW1x023483;
	Sun, 28 Jan 2007 21:34:32 -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: <17853.34664.178712.123312@satchel.alerce.com>
Date: Sun, 28 Jan 2007 21:34:32 -0800
To: freebsd-ports@freebsd.org
X-Mailer: VM 7.19 under 21.4 (patch 20) "Double Solitaire" XEmacs Lucid
X-Virus-Scanned: ClamAV using ClamSMTP
Subject: 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 05:56:24 -0000


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?

g.