X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id EA4819FA4AF for ; Tue, 2 May 2006 10:27:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 91386-10 for ; Tue, 2 May 2006 10:27:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from a2s5.a2hosting.com (host-209-124-50-10.a2webhosting.com [209.124.50.10]) by postgresql.org (Postfix) with ESMTP id B611B9FA25D for ; Tue, 2 May 2006 10:27:15 -0300 (ADT) Received: from adsl-153-96-23.tys.bellsouth.net ([70.153.96.23] helo=[192.168.1.10]) by a2s5.a2hosting.com with esmtpsa (TLSv1:RC4-SHA:128) (Exim 4.52) id 1FauuG-0000Kx-TR; Tue, 02 May 2006 09:27:13 -0400 In-Reply-To: <1146567751.2154.119.camel@hush.localdomain> References: <1146567751.2154.119.camel@hush.localdomain> Mime-Version: 1.0 (Apple Message framework v749.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <0F67FFD0-E5D0-4E39-AE2F-2E665F972FC2@pgedit.com> Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit From: John DeSoi Subject: Re: bad dump Date: Tue, 2 May 2006 09:26:52 -0400 To: tony X-Mailer: Apple Mail (2.749.3) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a2s5.a2hosting.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - pgedit.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/12 X-Sequence-Number: 21544 On May 2, 2006, at 7:02 AM, tony wrote: > Still fighting with my database dump from 8.1.1 here. > > I can not use this dump to rebuild the database in 7.3.4 (RHEL 3) or > 8.0.1 (mac OS X) > > I am convinced that the dump has issues... looked in the doc and don't > seem to be missing anything. I have been dumping and rebuilding for > the > last 6 years (pg version 7). I would have concerns about going from a newer version to an older version (the other way around is less problematic). But you gave no clues about specific errors or the format of the dump you are trying to load. John John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL