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 17B20DB341 for ; Tue, 1 Nov 2005 20:45:44 -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 67292-04 for ; Wed, 2 Nov 2005 00:45:40 +0000 (GMT) Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48]) by svr1.postgresql.org (Postfix) with ESMTP id 80D76DB30D for ; Tue, 1 Nov 2005 20:45:42 -0400 (AST) Received: from [192.168.1.11] ([151.200.59.178]) by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPA id <0IPA00110Y48F360@vms048.mailsrvcs.net> for pgsql-admin@postgresql.org; Tue, 01 Nov 2005 18:45:45 -0600 (CST) Date: Tue, 01 Nov 2005 19:47:26 -0500 From: Ferindo Middleton Jr Subject: how do you automate database backups? To: pgsql-admin@postgresql.org Reply-To: fmiddleton@verizon.net Message-id: <43680C9E.1080002@verizon.net> Organization: Sleek Collar MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit User-Agent: Thunderbird 1.4.1 (Windows/20051006) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.47 required=5 tests=[AWL=-0.449, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44] X-Spam-Score: 1.47 X-Spam-Level: * X-Archive-Number: 200511/15 X-Sequence-Number: 19388 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? Ferindo