Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 835159FA248 for ; Wed, 13 Dec 2006 00:54:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 50469-06 for ; Wed, 13 Dec 2006 00:53:57 -0400 (AST) X-Greylist: delayed 00:09:51.17166 by SQLgrey-1.7.4 Received: from ironport4.cable.net.co (ironport4.cable.net.co [200.118.0.15]) by postgresql.org (Postfix) with ESMTP id B17719F9F49 for ; Wed, 13 Dec 2006 00:53:57 -0400 (AST) Received: from nexus.cable.net.co ([200.118.2.51]) by ironport4.cable.net.co with ESMTP; 12 Dec 2006 23:43:35 +0000 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AgAAABL1fkXIdgIzh2dsb2JhbABBg1OJPwEBAQgOKg X-IronPort-AV: i="4.12,160,1165190400"; d="scan'208"; a="18289918:sNHT20867119" Received: from dynamic-ip-6979130237.cable.net.co ([69.79.130.237]) by nexus.cable.net.co (Sun Java System Messaging Server 6.1 HotFix 0.09 (built Dec 14 2004)) with ESMTPA id <0JA60087PBO8W6C0@nexus.cable.net.co> for pgsql-admin@postgresql.org; Tue, 12 Dec 2006 23:36:08 +0500 (GMT) Date: Tue, 12 Dec 2006 23:43:51 -0500 From: "Eduardo J. Ortega" Subject: Backup To: pgsql-admin@postgresql.org Message-id: <200612122343.54504.ejortegau@cable.net.co> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Content-disposition: inline User-Agent: KMail/1.9.5 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.043 tagged_above=0 required=5 tests=BAYES_50, INVALID_TZ_GMT X-Spam-Level: * X-Archive-Number: 200612/177 X-Sequence-Number: 23969 Hi there: Are there any nice (official or third party) backup utilities for postgres? I have a database which is several GB, so pg_dumping it to file and then bzipping2 every hour is not really the way to go. I've read a little about using WAL for incremental backup, but it sounds a little complicated and *very* user-error prone. (Not sure if this is the right place for it, but i really think that PG's developers should consider including a viable backup utility in the next version) thanks. -- Eduardo J. Ortega - Linux user #222873 "No fake - I'm a big fan of konqueror, and I use it for everything." -- Linus Torvalds