Upgrade 7.0.2 -> 7.1.2: Errors during Restore

From: Jim Caley <caley(at)chesco(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Upgrade 7.0.2 -> 7.1.2: Errors during Restore
Date: 2001-08-08 14:55:12
Message-ID: 3B7152D0.934D7BA9@chesco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-08-08 15:47:23 Re: Upgrade 7.0.2 -> 7.1.2: Errors during Restore
Previous Message Doug McNaught 2001-08-08 14:00:54 Re: Re: Still wondering about random numbers...