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 F39CE9DCAC0 for ; Sat, 17 Dec 2005 14:32:35 -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 26544-04 for ; Sat, 17 Dec 2005 14:32:34 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 52E399DCC79 for ; Sat, 17 Dec 2005 14:32:33 -0400 (AST) Received: from outkast.tienhuis.nl (outkast.tienhuis.nl [212.204.246.131]) by svr4.postgresql.org (Postfix) with ESMTP id E90D85AF0A5 for ; Sat, 17 Dec 2005 18:32:31 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by outkast.tienhuis.nl (Postfix-2.1.5 (TLS, IPv6)) with ESMTP id 31C0111420E; Sat, 17 Dec 2005 19:32:24 +0100 (CET) Received: from outkast.tienhuis.nl ([127.0.0.1]) by localhost (outkast [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09810-01; Sat, 17 Dec 2005 19:32:23 +0100 (CET) Received: from [192.168.1.33] (s55908057.adsl.wanadoo.nl [85.144.128.87]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by outkast.tienhuis.nl (Postfix-2.1.5 (TLS, IPv6)) with ESMTP id D5B9811420C; Sat, 17 Dec 2005 19:32:22 +0100 (CET) Message-ID: <43A459B8.9040800@tienhuis.nl> Date: Sat, 17 Dec 2005 19:32:24 +0100 From: Dick Visser User-Agent: Thunderbird 1.5 (Windows/20051025) MIME-Version: 1.0 To: Tom Lane , pgsql-admin@postgresql.org Subject: Re: binary vs. txt dumps with pg References: <43A3F676.5000109@tienhuis.nl> <8662.1134843452@sss.pgh.pa.us> In-Reply-To: <8662.1134843452@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at tienhuis.nl X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/183 X-Sequence-Number: 19903 Hi Tom > Have you retested this assumption recently? We got rid of the OIDs and > stuff in the default comments, so I think that you should be able to > just diff the text dump files without any weird processing. Hmmm you're right, they are the same now. I don't know what I did this week, but I was pretty sure the files were different. Nevermind then, as this saves time and effort. > There's a timestamp in the custom format file header. Ah OK that explains the different sums. Would it be an idea to make it a (default) configuration option for pg_dump to include a timestamp? You could work around it by disgarding the first X bytes when checksumming. Any idea what X would be? Best regards, -- * *** Dick Visser TIENHUIS Networking ** * * Touwbaan 68 P: +31206843731 * * *** 1018 HS Amsterdam F: +31208641420 * * * * The Netherlands M: +31622698108 * ** * IP-phone (SIP)/email: dick@tienhuis.nl * * * PGP-key: http://www.tienhuis.nl/gpg.txt * * * Webcam: http://www.tienhuis.nl/cam2.asx *** ***