Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 184D765029B for ; Tue, 21 Oct 2008 23:18:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 37110-02 for ; Tue, 21 Oct 2008 23:18:31 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.181]) by postgresql.org (Postfix) with ESMTP id 5B08E650164 for ; Tue, 21 Oct 2008 23:18:25 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id j4so1371451wah.19 for ; Tue, 21 Oct 2008 19:18:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=sqrdxwEtoZdUuV9zah9EJPNVewiONl7XR7tc/LQIvOc=; b=eftHSy1VCauB38KN/etLgf4QQV4nVXoZQ40//AE0WjxVLO91rfYYBEJJ42OUHax3c4 EAUMa2wHFuvg2E+fuU8lIKvEj4dNvxUQ4hZAt7FIlxD6OTUFzDeWgFbvIbk33zfqczSe xLbu/OXACKUo77+GXvDOYjktVg3rcSsfSfE1M= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=Qzs/YMw7DMdxLN3IorUZhXnTatkHhRlHPnO8J5YlefbeRyhsgUNCS2gG1TiIU1DrW1 KGdJ63T70AaToM2yGCgczUAk29vIwJHm6YoKjffOIlc0SCEgl9Pw7Zm3YRZgk6ahGhKf XMQVL3eZ/zQztml1snmFd0si+d9nuch9g/BYM= Received: by 10.114.192.3 with SMTP id p3mr7022478waf.189.1224641903889; Tue, 21 Oct 2008 19:18:23 -0700 (PDT) Received: by 10.114.39.11 with HTTP; Tue, 21 Oct 2008 19:18:23 -0700 (PDT) Message-ID: Date: Tue, 21 Oct 2008 20:18:23 -0600 From: "Scott Marlowe" To: "Marc Fromm" Subject: Re: pg_dumpall size Cc: "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/154 X-Sequence-Number: 30610 On Tue, Oct 21, 2008 at 11:56 AM, Marc Fromm wrote: > I have the same postgresql databases on two different servers. > > Boteh servers have the same version of postgresql, 8.1. > > The following backup command creates a file twice as big on one server, > compared to the other server. > > pg_dumpall -c -U postgres | gzip > alldb.gz Different default compression levels for gzip? try gzip -6 or something on both of them. Otherwise, unzip them and compare sizes to see if they really are the same unzipped.