X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id C91C3D1B4FE for ; Fri, 19 Sep 2003 11:40:01 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 22027-06 for ; Fri, 19 Sep 2003 08:39:53 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id EBA2FD1B509 for ; Fri, 19 Sep 2003 08:39:50 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h8JBdosn051829 for ; Fri, 19 Sep 2003 11:39:50 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h8JBCQTM048422 for pgsql-sql@postgresql.org; Fri, 19 Sep 2003 11:12:26 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Automated Backup Date: Fri, 19 Sep 2003 06:42:54 -0400 Organization: cbbrowne Computing Inc Lines: 14 Message-ID: References: <024b01c37e6f$a93fb4a0$7502a8c0@hdsc.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Rational FORTRAN, linux) Cancel-Lock: sha1:VVsN6onlcTMhrsKuF8xijvwDYX8= To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/190 X-Sequence-Number: 15168 Oops! sgnerd@yahoo.com.sg ("Kumar") was seen spray-painting on a wall: > Is there a way to automate the backup databases using pg_dump (like in SQL server)? If you can come up with a way of automating the running of programs, then I imagine that might be possible. I have heard that a program called "cron" might be used for this purpose. -- "aa454","@","freenet.carleton.ca" http://cbbrowne.com/info/x.html People can be set wondering by loading obscure personal patchable systems, and sending bug reports. Who would not stop and wonder upon seeing "Experimental TD80-TAPE 1.17, MegaDeath 2.5..."? The same for provocatively-named functions and variables in stack traces. -- from the Symbolics Guidelines for Sending Mail