Re: [GENERAL] trouble with pg_upgrade 9.0 -> 9.1

This is the first pg_upgrade mismatch report we have gotten about 9.1. 
I have asked the reporter for details.

Is what is the full 9.1 version number?

---------------------------------------------------------------------------

On Mon, Dec 17, 2012 at 03:33:40PM +0400, Groshev Andrey wrote:
> Hello!
> I'm trying to update a database from version 9.0 to 9.1 by pg_upgrade.
> The test is normal, but the actual conversion fails.
> This is a bug from pg_upgrade?
> I just saw this in the newsletter similar error with a note that it has been fixed in 9.1.2, but I already install
9.1.7.
> 
> My environment 
> centos 6.3 
> # uname -rm
> 2.6.32-279.14.1.el6.x86_64 x86_64
> 
> # rpm -qa |grep postgres
> postgresql90-devel-9.0.11-1PGDG.rhel6.x86_64
> postgresql91-9.1.7-1PGDG.rhel6.x86_64
> postgresql90-9.0.11-1PGDG.rhel6.x86_64
> postgresql90-server-9.0.11-1PGDG.rhel6.x86_64
> postgresql91-libs-9.1.7-1PGDG.rhel6.x86_64
> postgresql91-server-9.1.7-1PGDG.rhel6.x86_64
> postgresql91-devel-9.1.7-1PGDG.rhel6.x86_64
> postgresql90-libs-9.0.11-1PGDG.rhel6.x86_64
> postgresql90-contrib-9.0.11-1PGDG.rhel6.x86_64
> postgresql91-contrib-9.1.7-1PGDG.rhel6.x86_64
> 
> 
> # time sudo -u postgres sh -c '/usr/pgsql-9.1/bin/pg_upgrade -b /usr/pgsql-9.0/bin/ -B /usr/pgsql-9.1/bin/ -d
/var/lib/pgsql/9.0/data/-D /var/lib/pgsql/9.1/data/ -vvv -c -l ./log 2>&1 | iconv -f cp1251 -t utf-8'
 
> Running in verbose mode
> .....
> Running in verbose mode
> Running in verbose mode
> Performing Consistency Checks
> -----------------------------
> Checking current, bin, and data directories                 ok
> Checking cluster versions                                   ok
> "/usr/pgsql-9.0/bin/pg_ctl" -w -l "./log" -D "/var/lib/pgsql/9.0/data" -o "-p 5432 -c autovacuum=off -c
autovacuum_freeze_max_age=2000000000"start >> "./log" 2>&1
 
> 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
> "/usr/pgsql-9.0/bin/pg_ctl" -w -l "./log" -D "/var/lib/pgsql/9.0/data"  stop >> "./log" 2>&1
> "/usr/pgsql-9.1/bin/pg_ctl" -w -l "./log" -D "/var/lib/pgsql/9.1/data" -o "-p 5432 -b" start >> "./log" 2>&1
> Checking for presence of required libraries                 ok
> Checking database user is a superuser                       ok
> Checking for prepared transactions                          ok
> 
> *Clusters are compatible*
> "/usr/pgsql-9.1/bin/pg_ctl" -w -l "./log" -D "/var/lib/pgsql/9.1/data"  stop >> "./log" 2>&1
> 
> real    0m4.344s
> user    0m0.029s
> sys     0m0.051s
> 
> 
> 
> Checking current, bin, and data directories                 ok
> Checking cluster versions                                   ok
> "/usr/pgsql-9.0/bin/pg_ctl" -w -l "./log" -D "/var/lib/pgsql/9.0/data" -o "-p 5432 -c autovacuum=off -c
autovacuum_freeze_max_age=2000000000"start >> "./log
 
> " 2>&1
> 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                                       "/usr/pgsql-9.1/bin/pg_dumpall" --port 5432 --username
"postgres"--schema-only --binary-upgrade
 
> -f "/var/lib/pgsql/pg_upgrade/pg_upgrade_dump_all.sql"
> ok
> "/usr/pgsql-9.0/bin/pg_ctl" -w -l "./log" -D "/var/lib/pgsql/9.0/data"  stop >> "./log" 2>&1
> "/usr/pgsql-9.1/bin/pg_ctl" -w -l "./log" -D "/var/lib/pgsql/9.1/data" -o "-p 5432 -b" start >> "./log" 2>&1
> 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.
> | You will also need to remove the ".old" suffix
> | from /var/lib/pgsql/9.0/data/global/pg_control.old.
> 
> Performing Upgrade
> ------------------
> Adding ".old" suffix to old global/pg_control               ok
> Analyzing all rows in the new cluster                       "/usr/pgsql-9.1/bin/vacuumdb" --port 5432 --username
"postgres"--all --analyze >> "./log" 2>&1
 
> ok
> Freezing all rows on the new cluster                        "/usr/pgsql-9.1/bin/vacuumdb" --port 5432 --username
"postgres"--all --freeze >> "./log" 2>&1
 
> ok
> "/usr/pgsql-9.1/bin/pg_ctl" -w -l "./log" -D "/var/lib/pgsql/9.1/data"  stop >> "./log" 2>&1
> Deleting new commit clogs                                   ok
> Copying old commit clogs to new server                      cp -Rf "/var/lib/pgsql/9.0/data/pg_clog"
"/var/lib/pgsql/9.1/data/pg_clog"
> ok
> Setting next transaction id for new cluster                 "/usr/pgsql-9.1/bin/pg_resetxlog" -f -x 728832600
"/var/lib/pgsql/9.1/data"> /dev/null
 
> ok
> Resetting WAL archives                                      "/usr/pgsql-9.1/bin/pg_resetxlog" -l 3,2349,11
"/var/lib/pgsql/9.1/data">> "./log" 2>&1
 
> ok
> "/usr/pgsql-9.1/bin/pg_ctl" -w -l "./log" -D "/var/lib/pgsql/9.1/data" -o "-p 5432 -b" start >> "./log" 2>&1
> Setting frozenxid counters in new cluster                   ok
> Creating databases in the new cluster                       "/usr/pgsql-9.1/bin/psql" --set ON_ERROR_STOP=on
--no-psqlrc--port 5432 --username "postgres" -f
 
>  "/var/lib/pgsql/pg_upgrade/pg_upgrade_dump_globals.sql" --dbname template1 >> "./log"
> ok
> Adding support functions to new cluster                     ok
> Restoring database schema to new cluster                    "/usr/pgsql-9.1/bin/psql" --set ON_ERROR_STOP=on
--no-psqlrc--port 5432 --username "postgres" -f
 
>  "/var/lib/pgsql/pg_upgrade/pg_upgrade_dump_db.sql" --dbname template1 >> "./log"
> psql:/var/lib/pgsql/pg_upgrade/pg_upgrade_dump_db.sql:153584: ПРЕДУПРЕЖДЕНИЕ:  => как имя оператора считается
устаревшим
> DETAIL:  Это имя может быть вовсе запрещено в будущих версиях PostgreSQL.
> ok
> Removing support functions from new cluster                 ok
> Removing support functions from new cluster                 ok
> "/usr/pgsql-9.1/bin/pg_ctl" -w -l "./log" -D "/var/lib/pgsql/9.1/data"  stop >> "./log" 2>&1
> Restoring user relation files
> 
> Mismatch of relation names: database "database", old rel public.lob.ВерсияВнешнегоДокумента$Документ_pkey, new rel
public.plob.ВерсияВнешнегоДокумент
> а$Документ
> Failure, exiting
> 
> real    0m28.443s
> user    0m4.868s
> sys     0m0.921s
> 
> 
> -- 
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +