Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 346CA9F9F0E for ; Fri, 1 Dec 2006 14:06:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 28607-02 for ; Fri, 1 Dec 2006 14:06:07 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web31812.mail.mud.yahoo.com (web31812.mail.mud.yahoo.com [68.142.207.75]) by postgresql.org (Postfix) with SMTP id 211B09F9EED for ; Fri, 1 Dec 2006 14:06:07 -0400 (AST) Received: (qmail 42918 invoked by uid 60001); 1 Dec 2006 18:06:07 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=LH10Fwl3vE45jFLQVJfrutRYC004eDWeMqVwAlMX6PVxQslrokhGPYJMokjlSqEskVGD43TTUt7F9MpyVpLiZ96ke+mmrGD7oeOWJwYYkFJ+cspskxSFrcqQDz35QiE03yJvDDztZxZve5vlHWiaMpp4VTK5ZYRgUBJ6QrCfE4c=; X-YMail-OSG: _mtKVwsVM1nhShoEAF68u777osUAIeC8W_VAnAFGyhDKk5dexK1_xeTtBfdN2sqC2F6ESUtbSqyI8z1B7yK8kNnxxLM68xds7xrwiSbCH.ox2D0ln6ZWt7ZnQHbcO.hQaWLNUr3Vz_I- Received: from [12.177.97.50] by web31812.mail.mud.yahoo.com via HTTP; Fri, 01 Dec 2006 10:06:06 PST Date: Fri, 1 Dec 2006 10:06:06 -0800 (PST) From: Richard Broersma Jr Subject: Re: Backup of a big DB with a lot of large objects To: "Milen A. Radev" , pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <4617.40027.qm@web31812.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.146 tagged_above=0 required=5 tests=AWL, BAYES_20, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: * X-Archive-Number: 200612/6 X-Sequence-Number: 23798 > > Replicate it??? > > I'm hesitant about replacing backup with replication. It seems to me > like trying to shoot a mosquito with a cannon. One some threads that I've read, some posters mention that once their databases reach a certain size threshold, backups times become so large that replication seems to be the better perhaps only choice. I suppose that if replication is used, one of their child read-only servers can be dedicated the task of backing up the database thereby relieving that load off of the parent read/write server. But this doesn't solve the problem increasing back-up times. Of course, equipping yourself with a cannon now will really help after your mosquito grows in to an albatross. :o) Regards, Richard Broersma Jr.