From: | "Evan D(dot) Hoffman" <evandhoffman(at)gmail(dot)com> |
---|---|
To: | Postgresql Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 |
Date: | 2013-05-08 18:27:18 |
Message-ID: | CABRB-LtFZYjhRw0=iOivDUEcPARHHetKDr6NvZ8Y395coAO0zw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
I've tried several times to upgrade a test database (with real data,
~500 GB) from 9.1 to 9.2 using pg_upgrade and every time it fails with
the same error. I've tried a few different options to pg_upgrade but
always the same result. Nothing really useful has turned up in
Google. Any thoughts? Complete output is below:
-bash-4.1$ time /usr/pgsql-9.2/bin/pg_upgrade -b /usr/pgsql-9.1/bin/
-B /usr/pgsql-9.2/bin/ -d /var/lib/pgsql/9.1/data/ -D
/var/lib/pgsql/9.2/data/ -P 50433 --link
Performing Consistency Checks
-----------------------------
Checking current, bin, and data directories ok
Checking cluster versions ok
Checking database user is a superuser ok
Checking for prepared transactions ok
Checking for reg* system OID user data types ok
Checking for contrib/isn with bigint-passing mismatch ok
Creating catalog dump ok
Checking for presence of required libraries ok
Checking database user is a superuser ok
Checking for prepared transactions ok
If pg_upgrade fails after this point, you must re-initdb the
new cluster before continuing.
Performing Upgrade
------------------
Analyzing all rows in the new cluster ok
Freezing all rows on the new cluster ok
Deleting files from new pg_clog ok
Copying old pg_clog to new server ok
Setting next transaction ID for new cluster ok
Resetting WAL archives ok
Setting frozenxid counters in new cluster ok
Creating databases in the new cluster ok
Adding support functions to new cluster ok
Restoring database schema to new cluster ok
Removing support functions from new cluster ok
Adding ".old" suffix to old global/pg_control ok
If you want to start the old cluster, you will need to remove
the ".old" suffix from /var/lib/pgsql/9.1/data/global/pg_control.old.
Because "link" mode was used, the old cluster cannot be safely
started once the new cluster has been started.
Linking user relation files
/var/lib/pgsql/9.1/data/base/16406/3016054
Mismatch of relation OID in database "dbname": old OID 2938685, new OID 299721
Failure, exiting
real 12m31.600s
user 1m11.594s
sys 1m2.519s
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Neyman | 2013-05-08 18:35:30 | Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 |
Previous Message | Joshua Berry | 2013-05-08 16:39:36 | Re: Segmentation fault with core dump |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2013-05-08 18:30:26 | Re: RETURNING syntax for COPY |
Previous Message | Ryan Kelly | 2013-05-08 18:16:59 | Re: RETURNING syntax for COPY |