commit 3302334b48e2be6eb2c01dcf500363dbd4f22e59 Author: Bruce Momjian Date: Tue Jan 4 23:35:49 2011 -0500 In pg_upgrade, copy pg_largeobject_metadata and its index for 9.0+ servers because, like pg_largeobject, it is a system table whose contents are not dumped by pg_dump --schema-only. diff --git a/contrib/pg_upgrade/info.c b/contrib/pg_upgrade/info.c index 9e69ecd..8d566c0 100644 *** /tmp/I8SAQe_info.c Wed Jan 5 09:05:05 2011 --- /tmp/IOoIFc_info.c Wed Jan 5 09:05:05 2011 *************** get_rel_infos(ClusterInfo *cluster, DbIn *** 310,322 **** " ) OR ( " " n.nspname = 'pg_catalog' " " AND relname IN " ! " ('pg_largeobject', 'pg_largeobject_loid_pn_index') )) " " AND relkind IN ('r','t', 'i'%s)" "GROUP BY c.oid, n.nspname, c.relname, c.relfilenode," " c.reltoastrelid, t.spclocation, " " n.nspname " "ORDER BY t.spclocation, n.nspname, c.relname;", FirstNormalObjectId, /* see the comment at the top of old_8_3_create_sequence_script() */ (GET_MAJOR_VERSION(old_cluster.major_version) <= 803) ? "" : ", 'S'"); --- 310,325 ---- " ) OR ( " " n.nspname = 'pg_catalog' " " AND relname IN " ! " ('pg_largeobject', 'pg_largeobject_loid_pn_index'%s) )) " " AND relkind IN ('r','t', 'i'%s)" "GROUP BY c.oid, n.nspname, c.relname, c.relfilenode," " c.reltoastrelid, t.spclocation, " " n.nspname " "ORDER BY t.spclocation, n.nspname, c.relname;", FirstNormalObjectId, + /* does pg_largeobject_metadata need to be migrated? */ + (GET_MAJOR_VERSION(old_cluster.major_version) <= 804) ? + "" : ", 'pg_largeobject_metadata', 'pg_largeobject_metadata_oid_index'", /* see the comment at the top of old_8_3_create_sequence_script() */ (GET_MAJOR_VERSION(old_cluster.major_version) <= 803) ? "" : ", 'S'");