Questions about moving a restoring a dump from 8.1.11 to 8.2.16

Поиск
Список
Период
Сортировка
От Dai, Tino
Тема Questions about moving a restoring a dump from 8.1.11 to 8.2.16
Дата
Msg-id 1CA7FF980DA3824F9A5C31532B7A40DCC50DE3C7@LCXCLMB01.LCDS.LOC.GOV
обсуждение исходный текст
Ответы Re: Questions about moving a restoring a dump from 8.1.11 to 8.2.16  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_stat: last vacuum and analyze times are not being updated - v8.3.5
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Questions about moving a restoring a dump from 8.1.11 to 8.2.16