From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | reloading really big tables |
Date: | 2002-08-04 20:11:57 |
Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB04C73D62@snt452.corp.bcbsm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jim | 2002-08-05 00:46:51 | Primary Key: How Do I Generate One For Insert ... |
Previous Message | Steve Atkins | 2002-08-04 06:48:48 | Re: \d very, very, very slow |