Beginning with commit 002c105a0706bd1c1e939fe0f47ecdceeae6c52d
pg_upgrade will fail if there are orphaned temp tables in the current
database with the message 'old and new databases "postgres" have a
different number of relations'
On line 41 of pg_upgrade/info.c pg_upgrade checks that the number of
relations are the same but includes orphaned temp tables in the comparison.
Is this expected behavior? If so is there a more detailed error message
that can be added explain the cause of the failure? It wasn't evident
until modified pg_upgrade to show the missing oid's and recognized them
as temp tables with oid2name.
Dave Byrne
Phone: (310) 526-5000
Direct: (310) 526-5021
Email: DByrne@mdb.com<mailto:DByrne@mdb.com>
MDB CAPITAL GROUP LLC
Seeing Value Others Do Not, Creating Value Others Can Not.
401 Wilshire Boulevard, Suite 1020
Santa Monica, California 90401
www.mdb.com<http://www.mdb.com>
[MDB Capital Group]<http://www.mdb.com>
The IP Investment Bank