From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Subject: Re: Examining very large dumps
Date: Wed, 16 Apr 2008 12:58:29 +0300
Message-ID: <200804161258.30731.achill@matrix.gatewaynet.com> (raw)
In-Reply-To: <20080416095245.GC31097@easy2.in-chemnitz.de>
References: <200804161235.27157.achill@matrix.gatewaynet.com>
<20080416095245.GC31097@easy2.in-chemnitz.de>
Óôéò Wednesday 16 April 2008 12:52:45 ï/ç Tino Schwarze Ýãñáøå:
> 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.
Its a text dump. however less, tail, head seem dead slow, i'll try with some form
of grep.
I'd like to know if there is some kind of more efficient editor for viewing, searching
very large text files, searching by lineno or content.
>
> HTH,
>
> Tino.
>
> --
> âWhat we resist, persists.â (Zen saying)
>
> www.craniosacralzentrum.de
> www.forteego.de
>
--
Achilleas Mantzios
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com
Subject: Re: Examining very large dumps
In-Reply-To: <200804161258.30731.achill@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox