X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E8FFA5E4733 for ; Thu, 2 Sep 2004 10:42:11 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63170-02 for ; Thu, 2 Sep 2004 13:42:09 +0000 (GMT) Received: from sigfrido.unito.it (sigfrido.unito.it [130.192.119.69]) by svr1.postgresql.org (Postfix) with ESMTP id 84C9B5E46F8 for ; Thu, 2 Sep 2004 10:42:04 -0300 (ADT) Received: (from root@localhost) by sigfrido.unito.it (8.12.antani) id i82Dg7Pm021247 for pgsql-admin@postgresql.org; Thu, 2 Sep 2004 15:42:07 +0200 Received: from unito.it (pcuniv153.dspa.unito.it [130.192.105.153])by sigfrido.unito.it (8.12.antani) with ESMTP id i82Dg6xp020642for ; Thu, 2 Sep 2004 15:42:06 +0200 Message-ID: <413722B4.9040107@unito.it> Date: Thu, 02 Sep 2004 15:40:04 +0200 From: Sandro Garoffolo User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Create Linux Script for PostgreSQL database backup References: <20040901132055.17178.qmail@web61008.mail.yahoo.com> <200409020744.03552.tech@glastonburymusic.org.uk> <4136C42B.50303@tentacle.net> <4136EE84.8040001@3times25.net> In-Reply-To: <4136EE84.8040001@3times25.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-scanner: scanned by Inflex 1.0.12.7 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/25 X-Sequence-Number: 14728 Geoffrey wrote: > Kaolin Fire wrote: > >> For that matter: >> >> echo "1 3 * * * postgres /usr/local/bin/pg_dumpall > >> ~/backup.sql" >> /etc/crontab >> >> note to remember the two >>'s so you don't obliterate your crontab >> like I just did. > > > Unless things have changed, and they might have, you have to tell cron > to reread the crontab file for it to process your addition. Your > better solution is to use the tools designed for editing crontab, such > as 'crontab -e.' If you use this tool, crontab will automagically > reread the file. One question , if you set access to server with password in pg_hba.conf how can you pass the apssword in the script? _____________________________________________________________________ For your security, this mail has been scanned and protected by Inflex