[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-performance
Subject: [PERFORM] postgresql upgrade from 9.3 to 9.4 error
From: "Sheena, Prabhjot" <Prabhjot.Singh () classmates ! com>
Date: 2015-12-10 20:35:23
Message-ID: A68AE592-FAA0-4A63-A3FF-967895A0E3BF () classmates ! com
[Download RAW message or body]
[Attachment #2 (text/plain)]
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
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, \
sans-serif;"> <div>Guys I m trying to upgrade<b> postgresql 9.3 -> \
9.4 </b></div> <div><br>
</div>
<div>OS VERSION : CentOS release 6.3 (Final) \
(2.6.32-279.el6.x86_64.x86_64)</div> <div><br>
</div>
<div><br>
</div>
<div>When I run the upgrade script /usr/pgsql-9.4/bin/pg_upgrade</div>
<div><br>
</div>
<div>It gives me this error in the log file. </div>
<div><br>
</div>
<div><br>
</div>
<div>
<div><b>pg_restore: creating VIEW tables</b></div>
<div><b>pg_restore: [archiver (db)] Error while PROCESSING TOC:</b></div>
<div><b>pg_restore: [archiver (db)] Error from TOC entry 1206; 1259 10190710 VIEW \
tables postgres</b></div> <div><b>pg_restore: [archiver (db)] could not execute \
query: ERROR: column pg_class.reltoastidxid does not exist</b></div> \
<div><b>LINE 19: ELSE ( SELECT \
"pg_class"."reltoastidxid"</b></div> <div><b> \
\
^</b></div> <div><b> Command was:</b></div>
<div><b>-- For binary upgrade, must preserve pg_type oid</b></div>
<div><b>SELECT binary_upgrade.set_next_pg_type_oid('10190712'::pg_catalog.oid);</b></div>
<div><b><br>
</b></div>
<div><b><br>
</b></div>
<div><br>
</div>
</div>
<div>Please let me know what is going on here and what I can do to get this \
fixed</div> <div><br>
</div>
<div>Thanks</div>
<div>Prabhjot</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div id="MAC_OUTLOOK_SIGNATURE"></div>
</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic