postgresql upgrade from 9.3 to 9.4 error

From: "Sheena, Prabhjot" <Prabhjot(dot)Singh(at)classmates(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: postgresql upgrade from 9.3 to 9.4 error
Date: 2015-12-10 20:35:23
Message-ID: A68AE592-FAA0-4A63-A3FF-967895A0E3BF@classmates.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Browse pgsql-performance by date

  From Date Subject
Next Message Tory M Blue 2015-12-10 20:58:17 Re: checkpoints, proper config
Previous Message Joshua D. Drake 2015-12-10 20:00:38 Re: checkpoints, proper config