"Dai, Tino" <tdai@xxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin