From owner-freebsd-stable@FreeBSD.ORG  Wed Oct 13 15:45:41 2004
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
Delivered-To: freebsd-stable@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 6A00816A4CE
	for <freebsd-stable@freebsd.org>;
	Wed, 13 Oct 2004 15:45:41 +0000 (GMT)
Received: from f27.mail.ru (f27.mail.ru [194.67.57.191])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 20C4B43D46
	for <freebsd-stable@freebsd.org>;
	Wed, 13 Oct 2004 15:45:41 +0000 (GMT)	(envelope-from _pppp@mail.ru)
Received: from mail by f27.mail.ru with local 
	id 1CHlJo-000BOD-00; Wed, 13 Oct 2004 19:45:36 +0400
Received: from [81.200.13.122] by win.mail.ru with HTTP;
	Wed, 13 Oct 2004 19:45:36 +0400
From: dima <_pppp@mail.ru>
To: Norman Uittenbogaart <norman@webminded.nl>
Mime-Version: 1.0
X-Mailer: mPOP Web-Mail 2.19
X-Originating-IP: [81.200.13.122]
Date: Wed, 13 Oct 2004 19:45:36 +0400
In-Reply-To: <416D4546.9090308@webminded.nl>
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 8bit
Message-Id: <E1CHlJo-000BOD-00._pppp-mail-ru@f27.mail.ru>
cc: freebsd-stable@freebsd.org
Subject: Re: Postgres
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: dima <_pppp@mail.ru>
List-Id: Production branch of FreeBSD source code
	<freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 13 Oct 2004 15:45:41 -0000

> 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.
Do you use the correct .pgpass format?
It must be like that:
hostname:port:database:username: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 ...
> But it still asks for a password ...
Documentation claims the permissions should be 600.

> Does anybody know how to fix that ?
I happily use pg_dump & vacuumdb from crontab.