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 8D47453B7F for ; Thu, 31 Mar 2005 05:21:48 +0100 (BST) 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 86176-10 for ; Thu, 31 Mar 2005 04:21:45 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2640553B5B for ; Thu, 31 Mar 2005 05:21:45 +0100 (BST) 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 j2V4LfUk001830; Wed, 30 Mar 2005 23:21:44 -0500 (EST) To: Dario Cc: pgsql-admin@postgresql.org Subject: Re: postgres 7.2.1 pg_restore large objects In-reply-to: References: Comments: In-reply-to Dario message dated "Wed, 30 Mar 2005 18:41:43 -0300" Date: Wed, 30 Mar 2005 23:21:41 -0500 Message-ID: <1829.1112242901@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/497 X-Sequence-Number: 16995 Dario writes: > I have two different versions of postgres, one compiled by someone here, > and another version, installed via rpm. > unlikely, upgrading to a different version, is not an option, I probably > update to 7.2.(last version), but only if this specific problem is solved. If the release notes between 7.2.1 and 7.2.7 did not curl your toes, then you didn't understand what you were reading. There are numerous serious data-loss-grade bugs in 7.2.1. Update to 7.2.7 first and then see if you still have trouble loading this dump. If you do, I'd be interested to see more details ... but 7.2.1 isn't supportable. regards, tom lane