From owner-freebsd-questions@FreeBSD.ORG  Wed Oct 13 20:47:39 2004
Return-Path: <owner-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 6006B16A4CE
	for <freebsd-questions@freebsd.org>;
	Wed, 13 Oct 2004 20:47:39 +0000 (GMT)
Received: from 9.hellooperator.net (cpc3-cdif2-3-0-cust202.cdif.cable.ntl.com
	[81.103.32.202])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 16FF943D1F
	for <freebsd-questions@freebsd.org>;
	Wed, 13 Oct 2004 20:47:39 +0000 (GMT)
	(envelope-from rasputin@hellooperator.net)
Received: from rasputin by 9.hellooperator.net with local (Exim 4.43)
	id 1CHq23-0001vH-8L; Wed, 13 Oct 2004 21:47:35 +0100
Date: Wed, 13 Oct 2004 21:47:35 +0100
From: Dick Davies <rasputnik@hellooperator.net>
To: Norman Uittenbogaart <norman@webminded.nl>
Message-ID: <20041013204735.GO9309@lb.tenfour>
References: <416D4546.9090308@webminded.nl>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <416D4546.9090308@webminded.nl>
User-Agent: Mutt/1.4.2.1i
Sender: Rasputin <rasputin@hellooperator.net>
cc: FreeBSD Questions <freebsd-questions@freebsd.org>
Subject: Re: Postgres
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: Dick Davies <rasputnik@hellooperator.net>
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, 13 Oct 2004 20:47:39 -0000

* Norman Uittenbogaart <norman@webminded.nl> [1010 16:10]:
> I'm trying to write a backup script for postgres and us a crontab on it.
> In the manual it says for pg_dumpall make $HOME/.pgpass so it won't ask 
> for a password.
> Now I made the .pgpass in root's homedir (i wanted to use root's 
> crontab) paste the password in it, chmod 400 it ...

Can't you just pgdump from the local socket? And not bother with the password
thing at all?


-- 
I never meant to hurt you. Just destroy everything you ever believed in. - Bender
Rasputin :: Jack of All Trades - Master of Nuns