Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C12679FA274 for ; Wed, 13 Dec 2006 03:39:32 -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 58263-05 for ; Wed, 13 Dec 2006 03:39:18 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.229]) by postgresql.org (Postfix) with ESMTP id 2383A9FA1A1 for ; Wed, 13 Dec 2006 03:39:20 -0400 (AST) Received: by qb-out-0506.google.com with SMTP id e21so12455qba for ; Tue, 12 Dec 2006 23:39:18 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=LT4t4ul2zM+dtk892roDF0po6yvlI3KxT8Ox5u0Mwbv9fDUEZ/kSeFgO8OEjH/9KSNcGjAujCHemkf/Krdg0uEPvtfy53xgF9jsengsbcGc95FP2wsDRz9r4f+hi57Qhz4/eqcbD273XzKcKmHen0qrV6g60AlTrRwb3oXq00b4= Received: by 10.65.193.16 with SMTP id v16mr944936qbp.1165995558596; Tue, 12 Dec 2006 23:39:18 -0800 (PST) Received: by 10.65.206.17 with HTTP; Tue, 12 Dec 2006 23:39:18 -0800 (PST) Message-ID: Date: Wed, 13 Dec 2006 12:39:18 +0500 From: "Shoaib Mir" To: "Eduardo J. Ortega" Subject: Re: Backup Cc: pgsql-admin@postgresql.org In-Reply-To: <200612122343.54504.ejortegau@cable.net.co> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_90603_32847927.1165995558559" References: <200612122343.54504.ejortegau@cable.net.co> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/178 X-Sequence-Number: 23970 ------=_Part_90603_32847927.1165995558559 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline To me PITR looks like a very nice solution for incremental backup and even they can serve as a warm standby. What exactly are the complications you see with WAL archiving? --------------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 12/13/06, Eduardo J. Ortega wrote: > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > ------=_Part_90603_32847927.1165995558559 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline To me PITR looks like a very nice solution for incremental backup and even they can serve as a warm standby. What exactly are the complications you see with WAL archiving?

---------------
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)

On 12/13/06, Eduardo J. Ortega <ejortegau@cable.net.co > wrote:
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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

------=_Part_90603_32847927.1165995558559--