\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@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ It's impossible for everything to be true. +