Re: Examining very large dumps
От | Tino Schwarze |
---|---|
Тема | Re: Examining very large dumps |
Дата | |
Msg-id | 20080416095245.GC31097@easy2.in-chemnitz.de обсуждение исходный текст |
Ответ на | Examining very large dumps (Achilleas Mantzios <achill@matrix.gatewaynet.com>) |
Ответы |
Re: Examining very large dumps
|
Список | pgsql-admin |
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 handlethe > 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
В списке pgsql-admin по дате отправления: