Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DC3C29F95FF for ; Tue, 21 Aug 2007 17:44:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 94131-03 for ; Tue, 21 Aug 2007 17:44:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web33502.mail.mud.yahoo.com (web33502.mail.mud.yahoo.com [68.142.206.151]) by postgresql.org (Postfix) with SMTP id 5AFCE9F95B9 for ; Tue, 21 Aug 2007 17:44:36 -0300 (ADT) Received: (qmail 50074 invoked by uid 60001); 21 Aug 2007 20:44:35 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=FferZbXsXr9lsgCLM+Vie8pvFZ0y32yMxxZCtOZv19fxbjLDBAlmWkoLIDq7Ubsm64ym/qwxiw7a0sNcBfiKDj5MXDwE/UeePol1vYO2wUjT+MKvHmw6EY1B2AAfUEaC0Vq/AHjzlN/kpNYyAeK//wj9muffaFvRplcB2ewJF4g=; X-YMail-OSG: DC8tc7sVM1krPLVMmztX1HU9QtDAXbW_dHYpo4_RGw0moofQlVPJQyIcLkWaxoIBqChzYR4v1HF5LvUxDFQ4dV9_4U7Gd7pO99V.JMsv_XLbc0_ut9BkhLRXnVNc_g-- Received: from [130.14.254.26] by web33502.mail.mud.yahoo.com via HTTP; Tue, 21 Aug 2007 13:44:34 PDT Date: Tue, 21 Aug 2007 13:44:34 -0700 (PDT) From: Bolotov Pavel Subject: vacuum and database backup To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <978733.49771.qm@web33502.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/262 X-Sequence-Number: 26593 Hi How can i setup vacuum and database backup from crontab on ubuntu. The problem is that both programs ask password. Could you send an example script. Thanks Pavel. ____________________________________________________________________________________ Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. http://farechase.yahoo.com/