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 8B49FD8394 for ; Wed, 2 Nov 2005 12:35:26 -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 25058-01 for ; Wed, 2 Nov 2005 16:35:23 +0000 (GMT) Received: from mail.libertyrms.com (unknown [207.219.45.62]) by svr1.postgresql.org (Postfix) with ESMTP id 4F733D82EB for ; Wed, 2 Nov 2005 12:35:22 -0400 (AST) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1EXLa5-0001cD-SO for pgsql-admin@postgresql.org; Wed, 02 Nov 2005 11:35:21 -0500 Message-ID: <4368EAC9.7040508@ca.afilias.info> Date: Wed, 02 Nov 2005 11:35:21 -0500 From: Brad Nicholson User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: how do you automate database backups? References: <43680C9E.1080002@verizon.net> In-Reply-To: <43680C9E.1080002@verizon.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.452 required=5 tests=[AWL=-0.361, INFO_TLD=0.813] X-Spam-Score: 0.452 X-Spam-Level: X-Archive-Number: 200511/16 X-Sequence-Number: 19389 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. On Linux, you'd do as you mentioned write a script to do the dump. You'd schedule the script to run at the approriate time using cron. -- Brad Nicholson 416-673-4106 bnichols@ca.afilias.info Database Administrator, Afilias Canada Corp.