Upgrade 7.0.2 -> 7.1.2: Errors during Restore - Mailing list pgsql-general

From Jim Caley
Subject Upgrade 7.0.2 -> 7.1.2: Errors during Restore
Date
Msg-id 3B7152D0.934D7BA9@chesco.com
Whole thread Raw
Responses Re: Upgrade 7.0.2 -> 7.1.2: Errors during Restore
List pgsql-general
On my Red Hat Linux 6.2 box, I just upgraded from 7.0.2 to 7.1.2.  I used the
7.0.2 pg_dumpall, and after moving the 7.1.2 installation into place, firing up
postmaster, and running initdb I restored my pg_dumpall output.

The results of the restore seem to be fine, but there were a number of errors
during it and I want to make sure they're harmless.  My guess is they are,
especially since they didn't take place within the areas of the dump file where
my data was located.  A number of them seem to be throwbacks to 7.0RC1, based on
the path given in the messages.

I've pulled all the error messages and put them below.  Many of them regard
failure to stat regress.so, and then there are a variety of other ones regarding
nonexistent functions, etc.

I'd just like to know if I need to be concerned or not.

Thanks,
Jim

--------------------------------
ERRORS DURING RESTORE OF 7.0.2 DUMP TO 7.1.2:

psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:142: ERROR:  stat failed on f
ile '/usr/src/postgresql-7.0RC1/src/test/regress/input/../regress.so': No such f
ile or directory
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:143: ERROR:  stat failed on f
ile '/usr/src/postgresql-7.0RC1/src/test/regress/input/../regress.so': No such f
ile or directory
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:144: ERROR:  TypeCreate: func
tion 'widget_in(opaque)' does not exist
.
.
.
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:850: ERROR:  stat failed on f
ile '/usr/src/postgresql-7.0RC1/src/test/regress/input/../../../../contrib/spi/r
efint.so': No such file or directory
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:851: ERROR:  stat failed on f
ile '/usr/src/postgresql-7.0RC1/src/test/regress/input/../../../../contrib/spi/r
efint.so': No such file or directory
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:852: ERROR:  stat failed on f
ile '/usr/src/postgresql-7.0RC1/src/test/regress/input/../../../../contrib/spi/a
utoinc.so': No such file or directory
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:853: ERROR:  stat failed on f
ile '/usr/src/postgresql-7.0RC1/src/test/regress/input/../regress.so': No such f
ile or directory
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:854: ERROR:  stat failed on f
ile '/usr/src/postgresql-7.0RC1/src/test/regress/input/../regress.so': No such f
ile or directory
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:855: ERROR:  stat failed on f
ile '/usr/src/postgresql-7.0RC1/src/test/regress/input/../regress.so': No such f
ile or directory
.
.
.
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:863: ERROR:  ProcedureCreate:
 arg type 'widget' is not defined
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:864: ERROR:  stat failed on f
ile '/usr/src/postgresql-7.0RC1/src/test/regress/input/../regress.so': No such f
ile or directory
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:865: ERROR:  stat failed on f
ile '/usr/src/postgresql-7.0RC1/src/test/regress/input/../regress.so': No such f
ile or directory
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:866: ERROR:  stat failed on f
ile '/usr/src/postgresql-7.0RC1/src/test/regress/input/../regress.so': No such f
ile or directory
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:867: ERROR:  stat failed on f
ile '/usr/src/postgresql-7.0RC1/src/test/regress/input/../regress.so': No such f
ile or directory
.
.
.
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:1581: ERROR:  AggregateCreate
: function 'int4div(int4)' does not exist
CREATE
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:1583: NOTICE:  DefineAggregat
e: attribute "sfunc2" not recognized
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:1583: NOTICE:  DefineAggregat
e: attribute "stype2" not recognized
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:1583: NOTICE:  DefineAggregat
e: attribute "initcond2" not recognized
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:1583: ERROR:  Define: "stype"
 unspecified
CREATE
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:1592: ERROR:  OperatorGet: ri
ght type "widget" does not exist
.
.
.
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:118323: ERROR:  Function 'int
erpt_pp(path, path)' does not exist
        Unable to identify a function that satisfies the given argument types
        You may need to add explicit typecasts
.
.
.
psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:118341: ERROR:  Rule WHERE co
ndition may not contain references to other relations

END ERRORS

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Re: Still wondering about random numbers...
Next
From: Tom Lane
Date:
Subject: Re: Upgrade 7.0.2 -> 7.1.2: Errors during Restore