From owner-freebsd-stable@FreeBSD.ORG Wed Oct 27 05:30:56 2004 Return-Path: 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 DD1A616A4CE for ; Wed, 27 Oct 2004 05:30:56 +0000 (GMT) Received: from sku.tty.ch (sku.tty.ch [62.2.197.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id D4F6143D2D for ; Wed, 27 Oct 2004 05:30:53 +0000 (GMT) (envelope-from stable@sku.tty.ch) Received: from sku.tty.ch (localhost [127.0.0.1]) by sku.tty.ch (8.13.1/8.13.1) with ESMTP id i9QHp6SZ075262; Tue, 26 Oct 2004 17:51:06 GMT (envelope-from stable@sku.tty.ch) Received: (from stable@localhost) by sku.tty.ch (8.13.1/8.13.1/Submit) id i9QHp6lt075261; Tue, 26 Oct 2004 17:51:06 GMT (envelope-from stable) Message-Id: <200410261751.i9QHp6lt075261@sku.tty.ch> To: _pppp@mail.ru Date: Tue, 26 Oct 2004 17:51:06 +0000 (GMT) In-Reply-To: from "dima" at Oct 13, 2004 07:45:36 PM From: stable X-Mailer: ELM [version 2.5 PL6] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit cc: freebsd-stable@freebsd.org Subject: Re: Postgres X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 27 Oct 2004 05:30:57 -0000 if the perms really need to be 600 i would do this (anyway i dont see a reason why other users should access /root) chmod 700 /root chmod 600 /root/.pgpass also check the ownership of these files -- > > > 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. > _______________________________________________ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org" >