Guys I m trying to upgrade postgresql 9.3 -> 9.4 OS VERSION : CentOS release 6.3 (Final) (2.6.32-279.el6.x86_64.x86_64)
When I run the upgrade script /usr/pgsql-9.4/bin/pg_upgrade It gives me this error in the log file. pg_restore: creating VIEW tables pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 1206; 1259 10190710 VIEW tables postgres pg_restore: [archiver (db)] could not execute query: ERROR: column pg_class.reltoastidxid does not exist LINE 19: ELSE ( SELECT "pg_class"."reltoastidxid" ^ Command was: -- For binary upgrade, must preserve pg_type oid SELECT binary_upgrade.set_next_pg_type_oid('10190712'::pg_catalog.oid); Please let me know what is going on here and what I can do to get this fixed Thanks Prabhjot