X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 25DA7D8A01 for ; Wed, 2 Nov 2005 12:44:02 -0400 (AST) 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 22432-09 for ; Wed, 2 Nov 2005 16:44:00 +0000 (GMT) Received: from bramble.mmrd.com (bramble.mmrd.com [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id A0F9ED883F for ; Wed, 2 Nov 2005 12:44:00 -0400 (AST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id jA2HD6h3012529; Wed, 2 Nov 2005 12:13:06 -0500 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [10.225.10.110]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id jA2Ghwd12194; Wed, 2 Nov 2005 11:43:58 -0500 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id TWC09RGF; Wed, 2 Nov 2005 11:43:56 -0500 Subject: Re: how do you automate database backups? From: Robert Treat To: fmiddleton@verizon.net Cc: pgsql-admin@postgresql.org In-Reply-To: <43680C9E.1080002@verizon.net> References: <43680C9E.1080002@verizon.net> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 02 Nov 2005 11:43:57 -0500 Message-Id: <1130949838.2399.273.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.026 required=5 tests=[AWL=0.026] X-Spam-Score: 0.026 X-Spam-Level: X-Archive-Number: 200511/17 X-Sequence-Number: 19390 On Tue, 2005-11-01 at 19:47, Ferindo Middleton Jr wrote: > Are there tools available to automate backing up databases? I would like > to setup my PostgreSQL install to automatically backup databases and > save the file to specific location at specific times of the day with > little to no user intervention... I'd like to know how to do this in > both Windows and Linux. I imagine I could write some kind of script or > something on my Linux server but I have absolutely no idea how to > implement this on a computer running Windows. > > I would imagine this could be implemented through the OS but are there > built-in features of the database itself that can implement automated > backups? > It's not built into the database, you need some function of the os to run a script that makes use of pg_dump. In 'nix you can use cron, in winders I believe you can use 'task scheduler'. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL