X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 767B59DC9F3 for ; Mon, 19 Dec 2005 16:43:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41932-09 for ; Mon, 19 Dec 2005 16:43:38 -0400 (AST) X-Greylist: delayed 01:22:50.642879 by SQLgrey- Received: from noel.decibel.org (unknown [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id BA3189DC801 for ; Mon, 19 Dec 2005 16:43:35 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id BA9BD39829; Mon, 19 Dec 2005 14:43:33 -0600 (CST) Date: Mon, 19 Dec 2005 14:43:33 -0600 From: "Jim C. Nasby" To: Dick Visser Cc: Tom Lane , pgsql-admin@postgresql.org Subject: Re: binary vs. txt dumps with pg Message-ID: <20051219204333.GF28771@pervasive.com> References: <43A3F676.5000109@tienhuis.nl> <8662.1134843452@sss.pgh.pa.us> <43A459B8.9040800@tienhuis.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <43A459B8.9040800@tienhuis.nl> X-Operating-System: FreeBSD 6.0-RELEASE amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.03 required=5 tests=[AWL=0.030] X-Spam-Score: 0.03 X-Spam-Level: X-Archive-Number: 200512/205 X-Sequence-Number: 19925 On Sat, Dec 17, 2005 at 07:32:24PM +0100, Dick Visser wrote: > You could work around it by disgarding the first X bytes when > checksumming. Any idea what X would be? I believe that by default the custom format is gzip'd, which also means you probably couldn't exclude just the timestamp. Though if you're using rsync, I think there's a good chance it would only tranfer the first few hundred KB... -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461