X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 046E03CCEAD for ; Fri, 17 Dec 2004 16:57:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50071-01 for ; Fri, 17 Dec 2004 16:57:42 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9805A3CCEC0 for ; Fri, 17 Dec 2004 16:57:41 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id iBHGvZul020715; Fri, 17 Dec 2004 11:57:35 -0500 (EST) To: "Iain" Cc: pgsql-admin@postgresql.org Subject: Re: archive is compressed - any data will not be available In-reply-to: <000d01c4e421$ea62e560$7201a8c0@mst1x5r347kymb> References: <000d01c4e421$ea62e560$7201a8c0@mst1x5r347kymb> Comments: In-reply-to "Iain" message dated "Fri, 17 Dec 2004 19:19:28 +0900" Date: Fri, 17 Dec 2004 11:57:35 -0500 Message-ID: <20714.1103302655@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/195 X-Sequence-Number: 15781 "Iain" writes: > I was given a set of 3 dump files (in a tar.gz archive) generated by a 7.1 > DB that I'm trying to import into another 7.1 DB. 2 of the files (the > smaller ones) restore no problems, but one gives the above mentioned > message. Apparently you are trying to load into a server compiled with different options --- specifically, the destination software was built without zlib and so has no ability to read (nor create) compressed archives. Your choices are to go back to the source DB and tell pg_dump to dump without compression, or to rebuild the destination DB with zlib available. I think, but wouldn't entirely swear to it, that zlib is only used in pg_dump/pg_restore, so it might be sufficient to rebuild those two programs and not the whole Postgresql suite. regards, tom lane