Questions about moving a restoring a dump from 8.1.11 to 8.2.16

am 26.03.2010 02:43:02 von tdai

--_000_1CA7FF980DA3824F9A5C31532B7A40DCC50DE3C7LCXCLMB01LCDS LO_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi!

I shut down the database to upgrade from 8.1.11 to 8.2.16. We use pg_du=
mp
to dump and psql with the < sign to restore. But I had a problem with resto=
ring the
dump. I got a

ERROR: function "snb_ru_init(internal)" does not exist
CONTEXT: COPY pg_ts_dict, line 3, column dict_init: "snb_ru_init(internal)=
"

and I found this page on how to fix it:
http://www.penguinlinux.com/blog/lamp/tsearch2-with-postgres ql-82-errors/

Except I don't understand the steps that author has laid out. Especially
step 3.

Could some step me through this or do anybody have a better way to upgrade =
to
postgres 8.2.16?

Thanks,
Tino

--_000_1CA7FF980DA3824F9A5C31532B7A40DCC50DE3C7LCXCLMB01LCDS LO_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">

Hi!

I shut down the database to upgrade=
from
8.1.11 to 8.2.16. We use pg_dump

to dump and psql with the < sign to restore. But I =
had a
problem with restoring the

dump. I got a

ERROR: function "snb_ru_init(internal)"=
; does
not exist

CONTEXT: COPY pg_ts_dict, line 3, column dict_in=
it:
"snb_ru_init(internal)"

and I found this page on how to fix it:

href=3D"http://www.penguinlinux.com/blog/lamp/tsearch2-with- postgresql-82-e=
rrors/">http://www.penguinlinux.com/blog/lamp/tsearch2-with- postgresql-82-e=
rrors/

Except I don't understand the steps that author has la=
id
out. Especially

step 3.

Could some step me through this or do anybody have a b=
etter
way to upgrade to

postgres 8.2.16?

Thanks,

Tino

--_000_1CA7FF980DA3824F9A5C31532B7A40DCC50DE3C7LCXCLMB01LCDS LO_--

Re: Questions about moving a restoring a dump from 8.1.11 to 8.2.16

am 26.03.2010 03:19:57 von Tom Lane

"Dai, Tino" writes:
> I shut down the database to upgrade from 8.1.11 to 8.2.16. We use pg_dump
> to dump and psql with the < sign to restore. But I had a problem with restoring the
> dump. I got a

> ERROR: function "snb_ru_init(internal)" does not exist
> CONTEXT: COPY pg_ts_dict, line 3, column dict_init: "snb_ru_init(internal)"

Is that really the first error you got? It looks like you've neglected
to provide contrib/tsearch2 in the new installation.

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Questions about moving a restoring a dump from 8.1.11to 8.2.16

am 26.03.2010 05:40:18 von tdai

Hi Tom,

> Is that really the first error you got? It looks like you've neglected
> to provide contrib/tsearch2 in the new installation.

I actually double checked that I did have the tsearch2.so in my pgsql/lib d=
irectory.
What I was doing was not running the tsearch2.sql in the share/contrib dire=
ctory. Rather
I was dumping and the directly restoring into the 8.2 database.=20

What I did do was to import the share/contrib/tsearch2.sql into my database=
and then restore the dump=20
after that. I noticed some errors about not being able to create and modify=
the pg_ts_* tables
but didn't worry about that. It looked like all the tables are in and the p=
g_ts_* tables look good
too (compared them to the 8.1.11 pg_ts_* tables).

Thanks!
-Tino

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin