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 |