| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | panam <panam(at)gmx(dot)net> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: fix for pg_upgrade |
| Date: | 2011-09-24 14:43:52 |
| Message-ID: | 201109241443.p8OEhqt25732@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
\panam wrote:
> Hi, just tried to upgrade from 9.0 to 9.1 and got this error during
> pg_upgrade :
> Mismatch of relation id: database "xyz", old relid 465783, new relid 16494
> It seems, I get this error on every table as I got it on another table
> (which I did not need and deleted) before as well. Schmemas seem to be
> migrated but the content is missing.
>
> I am using Windows 7 64bit (both PG servers are 64 bit as well), everthing
> on the same machine.
Sorry for the delay in replying. It is odd you got a mismatch of relids
because pg_upgrade is supposed to preserve all of those. Can you do a
query to find out what table is relid of 465783 on the old cluster?
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2011-09-24 14:49:54 | Re: Range Types - symmetric |
| Previous Message | Andrew Dunstan | 2011-09-24 14:14:00 | Re: What Would You Like To Do? |