Questions about moving a restoring a dump from 8.1.11 to 8.2.16

From: "Dai, Tino" <tdai(at)loc(dot)gov>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Questions about moving a restoring a dump from 8.1.11 to 8.2.16
Date: 2010-03-26 01:43:02
Message-ID: 1CA7FF980DA3824F9A5C31532B7A40DCC50DE3C7@LCXCLMB01.LCDS.LOC.GOV
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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_init: "snb_ru_init(internal)"

and I found this page on how to fix it:
http://www.penguinlinux.com/blog/lamp/tsearch2-with-postgresql-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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-03-26 02:19:57 Re: Questions about moving a restoring a dump from 8.1.11 to 8.2.16
Previous Message Tom Lane 2010-03-25 16:01:37 Re: pg_stat: last vacuum and analyze times are not being updated - v8.3.5