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 > Re: Examining v...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 9 Topic 4918 of 5408
Post > Topic >>

Re: Examining very large dumps

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

=D3=F4=E9=F2 Wednesday 16 April 2008 12:52:45 =EF/=E7 Tino Schwarze =DD=E3=
=F1=E1=F8=E5:
> 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,
CO=
PY), i got some ugly ERRORs
> > denoting foreign key constraint violations.
> > Since the dump is 35 Gbytes, i'd like your advice for examining,
editin=
g, 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.
>=20
> 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
som=
e 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.
>=20
> HTH,
>=20
> Tino.
>=20
> --=20
> =E2=80=9EWhat we resist, persists.=E2=80=9D (Zen saying)
>=20
> www.craniosacralzentrum.de
> www.forteego.de
>=20



--=20
Achilleas Mantzios

--=20
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
tan12V112 Sat Oct 11 12:57:14 CDT 2008.