why so many error when I load the data to database from a script which generated by pg_dump.

Поиск

Список

Период

Сортировка

От	Yi Zhao
Тема	why so many error when I load the data to database from a script which generated by pg_dump.
Дата	2 августа 2008 г. 03:27:16
Msg-id	1217658168.3267.10.camel@localhost.localdomain обсуждение исходный текст
Ответы	Re: why so many error when I load the data to database from a script which generated by pg_dump.
Список	pgsql-general

Дерево обсуждения

hi, all:
I have a database to store the information about the html source of the
web page.
I wan't to move the data to another database, so I pg_dump the data to a
file:
    /usr/local/pgsql/bin/pg_dump htmldb -Upostgres -p 5433 > /tmp/dump.sql
now, I load the data into new database:
    /usr/local/pgsql/bin/psql -d newbd -Upostgres -p 5432 -f /tmp/dump.sql

but, I got some error about the "column error", for example:
----
psql:/export/chry.sql:1965134: ERROR:  missing data for column "content"
CONTEXT:  COPY htmlcontent, line 312807: "1207327    <!DOCTYPE HTML PUBLIC
"-//W3C//DTD
HTML 4.0 Transitional//EN">\n<html>\n<head>\n<meta http-e..."
----
I don't konw that why I can store it in a database, but I can't dump it
and reload into another one.

how to fix it?

my postgresql version: 8.3.3

thanks,

regards,

В списке pgsql-general по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

why so many error when I load the data to database from a script which generated by pg_dump.