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 0DBFD9FA4AF for ; Tue, 2 May 2006 11:44:34 -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 74211-10 for ; Tue, 2 May 2006 11:44:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.tgds.net (tgds.net [212.100.249.157]) by postgresql.org (Postfix) with ESMTP id 4658B9F9D4D for ; Tue, 2 May 2006 11:44:24 -0300 (ADT) Received: from hush.localdomain (localhost [127.0.0.1]) by mail.tgds.net (Postfix) with ESMTP id 615F91435F2; Tue, 2 May 2006 15:43:02 +0100 (BST) Subject: Re: bad dump From: tony To: John DeSoi Cc: pgsql-admin@postgresql.org In-Reply-To: References: <1146567751.2154.119.camel@hush.localdomain> <0F67FFD0-E5D0-4E39-AE2F-2E665F972FC2@pgedit.com> <1146578828.2154.153.camel@hush.localdomain> Content-Type: text/plain; charset=ISO-8859-15 Date: Tue, 02 May 2006 16:44:20 +0200 Message-Id: <1146581061.2154.176.camel@hush.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/18 X-Sequence-Number: 21550 Le mardi 02 mai 2006 à 10:26 -0400, John DeSoi a écrit : > 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. pg_dump with -d option and psql as per the doc lots of errors fly by during the restore the most remarkable being "illegal command \N" and "relation does not exist" for the non restored tables In the end the database exists I can connect to it and browse the data that is there. But like I said I am going back to the manual way that I used in the good old days. Thanks Tony