Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A21532E004B for ; Wed, 27 Feb 2008 23:33:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 39231-08 for ; Wed, 27 Feb 2008 23:33:48 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from server.firetrust.net (mailserver.firetrust.com [209.213.221.13]) by postgresql.org (Postfix) with ESMTP id 2C6C42E0048 for ; Wed, 27 Feb 2008 23:33:47 -0400 (AST) Received: from xpc (203-173-130-188.dsl.dyn.ihug.co.nz [203.173.130.188]) (authenticated bits=0) by server.firetrust.net (8.14.2/8.14.2) with ESMTP id m1S3XgBO002715 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Thu, 28 Feb 2008 16:33:45 +1300 Date: Thu, 28 Feb 2008 16:33:41 +1300 From: Steve Holdoway To: pgsql-admin@postgresql.org Subject: Re: trouble with pg_dumpall Message-Id: <20080228163341.e7fc28b8.steve.holdoway@firetrust.com> In-Reply-To: References: Organization: Firetrust Ltd. X-Mailer: Sylpheed 2.4.5 (GTK+ 2.12.0; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-MailWasher-Server-Scanned: Checked by MailWasher server v2.2.3 (www.Firetrust.com) X-MailWasher-Server-Status: Clean X-Virus-Scanned: ClamAV 0.92/6021/Thu Feb 28 12:55:48 2008 on server.firetrust.net X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/385 X-Sequence-Number: 28459 On Wed, 27 Feb 2008 17:12:40 -0800 "Tena Sakai" wrote: Here's your problem. > . .bashrc You have an extremely minimal environment when running from cron, and you certainly *aren't* running from the home directory of the relevant user. You need to set up your PATH and HOME manually, and cd to your home directory before sourcing .bashrc for this to work. . ~/.bashrc *might* work, but it's better to be specific (: hth, Steve -- Steve Holdoway