From owner-freebsd-questions@FreeBSD.ORG Thu Jun 9 11:45:34 2005 Return-Path: X-Original-To: freebsd-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 334F116A41C for ; Thu, 9 Jun 2005 11:45:34 +0000 (GMT) (envelope-from lane@joeandlane.com) Received: from smtpauth04.mail.atl.earthlink.net (smtpauth04.mail.atl.earthlink.net [209.86.89.64]) by mx1.FreeBSD.org (Postfix) with ESMTP id AA70B43D55 for ; Thu, 9 Jun 2005 11:45:33 +0000 (GMT) (envelope-from lane@joeandlane.com) Received: from [66.47.111.183] (helo=joeandlane.com) by smtpauth04.mail.atl.earthlink.net with asmtp (TLSv1:AES256-SHA:256) (Exim 4.34) id 1DgLTY-0008R5-MM for freebsd-questions@freebsd.org; Thu, 09 Jun 2005 07:45:32 -0400 Received: from joeandlane.com (localhost [127.0.0.1]) by joeandlane.com (8.13.1/8.13.1) with ESMTP id j59BqOf0011938 for ; Thu, 9 Jun 2005 06:52:24 -0500 (CDT) (envelope-from lane@joeandlane.com) Received: from localhost (localhost [[UNIX: localhost]]) by joeandlane.com (8.13.1/8.13.1/Submit) id j59BqOUJ011937 for freebsd-questions@freebsd.org; Thu, 9 Jun 2005 06:52:24 -0500 (CDT) (envelope-from lane@joeandlane.com) From: Lane To: freebsd-questions@freebsd.org Date: Thu, 9 Jun 2005 06:52:23 -0500 User-Agent: KMail/1.8 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200506090652.24169.lane@joeandlane.com> X-ELNK-Trace: e56a4b6ca9bdfda11aa676d7e74259b7b3291a7d08dfec794050952a30d7d764b785a9be0356c280350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 66.47.111.183 Subject: mgsql periodic script? running vacuumdb? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 09 Jun 2005 11:45:34 -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