Re: Error migrating from Postgres 6.3.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Luis Martínez <luimarma(at)iti(dot)upv(dot)es>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Error migrating from Postgres 6.3.2
Date: 2001-03-26 15:31:38
Message-ID: 28693.985620698@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Luis =?iso-8859-1?q?Mart=EDnez?= <luimarma(at)iti(dot)upv(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ross J. Reedstrom 2001-03-26 17:35:25 Re: Sorry, too many clients already
Previous Message Luis Martínez 2001-03-26 15:02:03 Error migrating from Postgres 6.3.2