Обсуждение: Error migrating from Postgres 6.3.2

I am migrating from postgres 6.3.2 to 7.1 Beta6. After performing a
pg_dumpall > backupfile on my old pgsql version I try to restore the data
with psql -d template1 -f backupfile, but I get "Unable to locate type name
'char16' in catalog" on tables such as onek, tenk1 ,tenk2....

What is the problem?
Shoul I replace this type with some other?

Thanks for your help in advance,

Luis,
--
----------------------------------------------------------------------
Luis   Javier Martínez Martínez   Instituto Tecnológico de Informática
Telf:  34 (9) 63 87 72 33         Universidad  Politécnica de Valencia
Email: luimarma@iti.upv.es        Camino de Vera s/n    46071 Valencia
----------------------------------------------------------------------

Luis =?iso-8859-1?q?Mart=EDnez?= <luimarma@iti.upv.es> writes:
> I am migrating from postgres 6.3.2 to 7.1 Beta6. After performing a
> pg_dumpall > backupfile on my old pgsql version I try to restore the data
> with psql -d template1 -f backupfile, but I get "Unable to locate type name
> 'char16' in catalog" on tables such as onek, tenk1 ,tenk2....

Those look suspiciously like tables in the regression tests; I bet you
ran the regression tests in 6.3.2 and never bothered to clean up afterwards.
Consider just cutting the whole regression-database section out of the
backupfile.

            regards, tom lane