reloading really big tables

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

Responses

Browse pgsql-general by date

  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