Skip site navigation (1) Skip section navigation (2)

Re: Examining very large dumps

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Examining very large dumps
Date: 2008-04-16 09:58:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Στις 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)

Achilleas Mantzios

In response to


pgsql-admin by date

Next:From: Tino SchwarzeDate: 2008-04-16 10:07:43
Subject: Re: Examining very large dumps
Previous:From: Tino SchwarzeDate: 2008-04-16 09:52:45
Subject: Re: Examining very large dumps

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group