From owner-freebsd-questions@FreeBSD.ORG  Wed May 24 07:39:11 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 32D9E16A496
	for <freebsd-questions@freebsd.org>;
	Wed, 24 May 2006 07:39:11 +0000 (UTC)
	(envelope-from gandalf@messias.qhigh.com)
Received: from smtp.enternet.hu (smtp.enternet.hu [62.112.192.21])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 9E7D443D58
	for <freebsd-questions@freebsd.org>;
	Wed, 24 May 2006 07:39:04 +0000 (GMT)
	(envelope-from gandalf@messias.qhigh.com)
Received: from [62.112.200.65] (helo=[172.16.0.43])
	by smtp.enternet.hu with esmtpa (Exim 4) id 1FinxN-0004aA-Vr
	for freebsd-questions@freebsd.org; Wed, 24 May 2006 09:39:02 +0200
Message-ID: <44740DBD.1090303@messias.qhigh.com>
Date: Wed, 24 May 2006 09:39:41 +0200
From: User Gandalf <gandalf@messias.qhigh.com>
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
To: freebsd-questions@freebsd.org
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Postgresql Autovacuum how?
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: Wed, 24 May 2006 07:39:12 -0000


  Hello,

I have FreeBSD 6.1 and PostgreSQL 8.1.3 installed. I had to change the 
pg_hba.conf settings, because I need to open the 5432 port for everyone 
(SSL enabled). For this reason, I also gave strong passwords for all 
postgresql users. Now this is what I see in the daily run output 
(/usr/local/etc/periodic/daily/502.pgsql):

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

Errors were reported during vacuum.


This is my pg_hba.conf file:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
# "local" is for Unix domain socket connections only
local   all         all                               ident     sameuser
host    all         all         127.0.0.1/32          md5
hostssl all         all         0.0.0.0 0.0.0.0       md5

The autovacuum script was packaged for FreeBSD, so I assume this is a 
FreeBSD specific thing. My question is: why ident/sameuser not working 
here? How can I enable auto vacuums without storing the password in the 
periodic/daily/502.pgsql  script?

Thanks,

   Laszlo