From owner-freebsd-questions@FreeBSD.ORG  Thu Jun  9 14:44:44 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: questions@freebsd.org
Delivered-To: freebsd-questions@FreeBSD.ORG
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 8271D16A41C
	for <questions@freebsd.org>; Thu,  9 Jun 2005 14:44:44 +0000 (GMT)
	(envelope-from lane@joeandlane.com)
Received: from smtpauth08.mail.atl.earthlink.net
	(smtpauth08.mail.atl.earthlink.net [209.86.89.68])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 4296E43D48
	for <questions@freebsd.org>; Thu,  9 Jun 2005 14:44:44 +0000 (GMT)
	(envelope-from lane@joeandlane.com)
Received: from [66.47.111.183] (helo=joeandlane.com)
	by smtpauth08.mail.atl.earthlink.net with asmtp (TLSv1:AES256-SHA:256)
	(Exim 4.34) id 1DgOGx-0007em-LV
	for questions@freebsd.org; Thu, 09 Jun 2005 10:44:43 -0400
Received: from joeandlane.com (localhost [127.0.0.1])
	by joeandlane.com (8.13.1/8.13.1) with ESMTP id j59EpYBn013220
	for <questions@freebsd.org>; Thu, 9 Jun 2005 09:51:34 -0500 (CDT)
	(envelope-from lane@joeandlane.com)
Received: from localhost (localhost [[UNIX: localhost]])
	by joeandlane.com (8.13.1/8.13.1/Submit) id j59EpYne013219
	for questions@freebsd.org; Thu, 9 Jun 2005 09:51:34 -0500 (CDT)
	(envelope-from lane@joeandlane.com)
From: Lane <lane@joeandlane.com>
To: questions@freebsd.org
Date: Thu, 9 Jun 2005 09:51:33 -0500
User-Agent: KMail/1.8
References: <200506090652.24169.lane@joeandlane.com>
In-Reply-To: <200506090652.24169.lane@joeandlane.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200506090951.33943.lane@joeandlane.com>
X-ELNK-Trace: e56a4b6ca9bdfda11aa676d7e74259b7b3291a7d08dfec79ffa31e27aed2216d1353efc626965da7350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c
X-Originating-IP: 66.47.111.183
Cc: 
Subject: Re: Pgsql periodic script? running vacuumdb?
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 09 Jun 2005 14:44:44 -0000

Hello,

I recently installed postgresql 8.0 on FreeBSD 5.4 and I've noticed the
following message in the "daily run output":

vacuuming...
Password:
vacuumdb: could not connect to database template1: fe_sendauth: no password
supplied

Errors were reported during vacuum.

I know how to fix the promblem (i.e. ~/.pgpass) but what I don't understand
is who or what is invoking vacuumdb.

The message appears in the output generated from the scripts
at /etc/periodic/daily but there is no reference to vacuumdb in any of
those scripts.

Who's doing this?

Thanks,

Lane

Whoops!  that's pgsql, not mgsql ... don't even know what mgsql is!