migration
От | Boris Makovecki |
---|---|
Тема | migration |
Дата | |
Msg-id | WorldClient-F200502221341.AA41330241@abak.net обсуждение исходный текст |
Ответы |
Re: migration
|
Список | pgsql-general |
I'm having trouble migrating DB from postgreSQL 7.4 to 7.4.7:
During restore I'm geting all kind of errors like :
********************************************************************
ERROR: column "txt_name" has a type conflict
DETAIL: character varying versus pg_catalog.varchar
********************************************************************
(txt_name is inherited field)
********************************************************************
ERROR: relation "doc_inventory" does not exist
ERROR: column "txt_name" has a type conflict
DETAIL: character varying versus pg_catalog.varchar
********************************************************************
(txt_name is inherited field)
********************************************************************
ERROR: relation "doc_inventory" does not exist
ERROR: column "f_has_doc" is of type boolean but expression is of type integer
HINT: You will need to rewrite or cast the expression.
HINT: You will need to rewrite or cast the expression.
ERROR: column "dat_pay_term_in" is of type timestamp without time zone but expression is of type integer
HINT: You will need to rewrite or cast the expression.
HINT: You will need to rewrite or cast the expression.
********************************************************************
I've also tryed to move DB from 7.4 (linux) to 7.4 (cygwin) but same errors acured.
I've also tryed to move DB from 7.4 (linux) to 7.4 (cygwin) but same errors acured.
Is there some bug in 7.4 or pg_dumpall i should know about ?
Any idea?
Boris
В списке pgsql-general по дате отправления: