reloading really big tables - Mailing list pgsql-general

From Johnson, Shaunn
Subject reloading really big tables
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB04C73D62@snt452.corp.bcbsm.com
Whole thread Raw
Responses Re: reloading really big tables  (Steve Lane <slane@fmpro.com>)
List pgsql-general

Howdy:

Moving data from PostgreSQL 7.1.3 to PostgreSQL 7.2.1
and am trying to reload a few tables (large ones).

So, to save my original tables, I used
the new pg_dump (7.2.1) and have them as flat files.
When I try to restore some of the files, I get:

[error]

psql:table_detail.Fri:48:
ERROR:  copy: line 1, value too long for type character(1)

psql:table_detail.Fri:48:
lost synchronization with server, resetting connection

[/error]

What does this mean?  Why isn't the table recreated?
Is it too big?  It seems that smaller tables are okay
when I restore them.

I've also tried the " cat file| psql -U postgres -d database "
and still get the same error. 

Suggestions?

Thanks!

-X

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: \d very, very, very slow
Next
From: "Markus Wollny"
Date:
Subject: Re: Questions regarding contrib/tsearch