From owner-freebsd-questions@FreeBSD.ORG  Wed May 24 09:36:50 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 6D01216A506
	for <freebsd-questions@freebsd.org>;
	Wed, 24 May 2006 09:36:50 +0000 (UTC)
	(envelope-from nagylzs@freemail.hu)
Received: from smtp.enternet.hu (smtp.enternet.hu [62.112.192.21])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 542EE43D7C
	for <freebsd-questions@freebsd.org>;
	Wed, 24 May 2006 09:36:44 +0000 (GMT)
	(envelope-from nagylzs@freemail.hu)
Received: from [62.112.200.65] (helo=[172.16.0.43])
	by smtp.enternet.hu with esmtpa (Exim 4)
	id 1Fipmk-0006NL-Ab; Wed, 24 May 2006 11:36:10 +0200
Message-ID: <44742932.4030008@freemail.hu>
Date: Wed, 24 May 2006 11:36:50 +0200
From: =?ISO-8859-2?Q?Nagy_L=E1szl=F3_Zsolt?= <nagylzs@freemail.hu>
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
To: Nick Withers <nick@nickwithers.com>,  freebsd-questions@freebsd.org
References: <44740DBD.1090303@messias.qhigh.com>
	<20060524175020.9f54dfae.nick@nickwithers.com>
In-Reply-To: <20060524175020.9f54dfae.nick@nickwithers.com>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit
Cc: 
Subject: Re: 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 09:36:53 -0000


> I've created a .pgpass file in /root (which is read only by
> root) containing the password for the pgsql user. A quick
> Google on "pgpass" turned up this content from
> http://pgsqld.active-venture.com/libpq-files.html:
>   
That link is broken, but here is a good one:

http://www.postgresql.org/docs/8.1/interactive/libpq-pgpass.html

I had to put in into ~pgsql/.pgpass.

However, for other users, it works for me ONLY if the database name and 
the user name are the same.
Otherwise it prompts for a password. But that is antoher problem.

Thanks,

  Laci