Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Admin > Examining very ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 9 Topic 4918 of 5156
Post > Topic >>

Examining very large dumps

by achill@[EMAIL PROTECTED] (Achilleas Mantzios) Apr 16, 2008 at 12:35 PM

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 ****tions 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.

Thank you very much for any help.
It's been the first day of the upgrade effort, and if i judge from the
begining, the rest of the process will not be any easier.
-- 
Achilleas Mantzios

-- 
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
 




 9 Posts in Topic:
Examining very large dumps
achill@[EMAIL PROTECTED]   2008-04-16 12:35:26 
Re: Examining very large dumps
postgresql@[EMAIL PROTECT  2008-04-16 11:52:45 
Re: Examining very large dumps
achill@[EMAIL PROTECTED]   2008-04-16 12:58:29 
Re: Examining very large dumps
postgresql@[EMAIL PROTECT  2008-04-16 12:07:43 
Re: Examining very large dumps
tgl@[EMAIL PROTECTED] (T  2008-04-16 11:23:40 
Re: Examining very large dumps
tgl@[EMAIL PROTECTED] (T  2008-04-17 01:25:22 
Re: Examining very large dumps
achill@[EMAIL PROTECTED]   2008-04-17 08:46:24 
Re: Examining very large dumps
achill@[EMAIL PROTECTED]   2008-04-17 17:15:55 
Re: Examining very large dumps
phillip.smith@[EMAIL PROT  2008-04-17 12:08:51 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 1:33:31 CDT 2008.