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 87EE59F9D4D for ; Tue, 2 May 2006 11:27:03 -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 44797-07 for ; Tue, 2 May 2006 11:26:44 -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 BF05B9F9CC1 for ; Tue, 2 May 2006 11:26:44 -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 1Favpn-0002YZ-Rs; Tue, 02 May 2006 10:26:40 -0400 In-Reply-To: <1146578828.2154.153.camel@hush.localdomain> References: <1146567751.2154.119.camel@hush.localdomain> <0F67FFD0-E5D0-4E39-AE2F-2E665F972FC2@pgedit.com> <1146578828.2154.153.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: Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit From: John DeSoi Subject: Re: bad dump Date: Tue, 2 May 2006 10:26:19 -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/17 X-Sequence-Number: 21549 On May 2, 2006, at 10:07 AM, tony wrote: > Reading through in a text editor (nedit) rather than with pico or nano > in a terminal the sql colour coding gives me a clue: > > - the data contains non escaped ' as in "d'Anjou" > > Is this my issue? Again, you have not posted exactly what the error is. Show the commands you used to dump and restore and include the exact error output from the restore operation. John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL