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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
