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
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 |