X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id BE2F29FB2FA for ; Thu, 10 Aug 2006 16:00:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 62593-02 for ; Thu, 10 Aug 2006 19:00:27 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail15.bluewin.ch (mail15.bluewin.ch [195.186.18.63]) by postgresql.org (Postfix) with ESMTP id 8F93E9FB2F8 for ; Thu, 10 Aug 2006 16:00:27 -0300 (ADT) Received: from [192.168.1.74] (83.77.187.219) by mail15.bluewin.ch (Bluewin 7.3.110.2) id 4492529600CBF67E for pgsql-admin@postgresql.org; Thu, 10 Aug 2006 19:00:25 +0000 From: Ivo Rossacher To: pgsql-admin@postgresql.org Subject: Re: pg_dump from crontab Date: Thu, 10 Aug 2006 21:00:09 +0200 User-Agent: KMail/1.8.2 References: <221385EC3F18A44DB0925467A1D2395F568D6D@exsrv3.workskillsprofessionals.com.au> In-Reply-To: <221385EC3F18A44DB0925467A1D2395F568D6D@exsrv3.workskillsprofessionals.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200608102100.10084.rossacher@bluewin.ch> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/145 X-Sequence-Number: 22688 Am Freitag, 4. August 2006 09.20 schrieb Nirav Parikh: > Hi, > > I am having problem backing up database from crontab, I got following > lines in crontab file > > > 0 20 * * 5 /usr/pgsql/bin/pg_dump -F c database > > /usr/backup/friDATE4.pgdump > 0 20 * * 4 pg_dump -F c database > /usr/backup/thurDATE06-3.pgdump > > none of them works, I have given full permission to everyone in > /usr/backup directory > > it creates the dump file but with 0 size - empty! > > I have other commands in crontab which executes normally, also pg_dump > command works through command line. > > does anyone what else I can check? Probably the permission at the database which the user has that owns the crontab file? Does the command work in a shell of this user? Best regards Ivo > > > > > Regards, > > > > > > Nirav