Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 86AB32E0038 for ; Wed, 16 Apr 2008 06:52:55 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 14488-04 for ; Wed, 16 Apr 2008 06:52:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by developer.postgresql.org (Postfix) with ESMTP id E8D022E0037 for ; Wed, 16 Apr 2008 06:52:48 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 64E7D470006 for ; Wed, 16 Apr 2008 11:52:45 +0200 (CEST) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id VUNS7EKRT9RK for ; Wed, 16 Apr 2008 11:52:45 +0200 (CEST) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 526C2470003; Wed, 16 Apr 2008 11:52:45 +0200 (CEST) Date: Wed, 16 Apr 2008 11:52:45 +0200 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: Examining very large dumps Message-ID: <20080416095245.GC31097@easy2.in-chemnitz.de> References: <200804161235.27157.achill@matrix.gatewaynet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <200804161235.27157.achill@matrix.gatewaynet.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/156 X-Sequence-Number: 28920 On Wed, Apr 16, 2008 at 12:35:26PM +0300, Achilleas Mantzios wrote: > Hi, i just started the process of migrating from 7.4 to 8.3.1. > On restoring, apart from the easily explainable ERRORs (both in DDL, COPY), i got some ugly ERRORs > denoting foreign key constraint violations. > Since the dump is 35 Gbytes, i'd like your advice for examining, editing, extracting portions of large dumps, > in order to find the cause of the problem. vim (linux), vi (FreeBSD) or any other unix editor i tried, could not handle the > volume. Do you have a plain text dump or a compressed archive? Try using less for a first view, then extract things with grep or alter with sed. HTH, Tino. -- „What we resist, persists.” (Zen saying) www.craniosacralzentrum.de www.forteego.de